how to determine where a select statement fails

From: "Heather Johnson" <hjohnson(at)nypost(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Subject: how to determine where a select statement fails
Date: 2001-07-26 15:15:06
Message-ID: 00a701c115e5$c0c4c6a0$9d0c10ac@1211.nypost.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

I am using php to do a select query which returns rows on the condition that
a conjunction is true in the WHERE clause. This is the SELECT statement:

SELECT low_range, high_range, st_name, city, zip FROM router
WHERE st_name = '$st_name' AND city = '$city' AND zip = '$zip';

In the event that the query fails to return any rows, I'd like to be able to
determine which conjunct caused it to fail. So, for example, if the
user-entered $st_name isn't in the router table, I'd like to know that
st_name = '$st_name' is what made the conjunction false and caused the query
to fail. $pg_errormsg isn't this specific about query failures though. Does
anyone know how I might be able to get this information?

Thanks!
Heather Johnson

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Timothy_Maguire 2001-07-26 15:35:49 Re: how to determine where a select statement fails
Previous Message GH 2001-07-25 08:23:30 Re: button tag problem