query string returned when no records matched

From: "LLOYD,DAN (HP-Boise,ex1)" <dan(dot)lloyd(at)hp(dot)com>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: query string returned when no records matched
Date: 2003-07-22 04:11:21
Message-ID: 345D43ADFFFF864298F9ECD6C5D574E82BADE9@xboi21.boise.itc.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

When using PostgreSQL 7.3.x on either Linux or HP-UX hosts, the SQL query
string is returned when the query finishes without error but finds no
matching records. This ends up being visible in the client's web browser.

An example search would start like "SELECT DISTINCT ON (test_result_name,
entry_time) entry_time, ..." then show up in the html as plain text that is
created in the JavaServer Page (JSP). The same thing happens when running
the query in Webmin which is not tied to anything I wrote.

What I am looking for is hopefully some PostgreSQL configuration setting to
suppress the query string being reflected back to me. The JSP handles the
resulting empty table just fine but the string pollutes the html page.

TIA,Dan

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Abhishek Goyal 2003-07-22 04:24:57 Postgres Database Error Codes
Previous Message Bruce Momjian 2003-07-21 19:24:22 Re: Where do I get LIBPQEASY?