From: Bill Moran <wmoran@potentialtech.com>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-php@postgresql.org
Subject: Re: pg_query_params
Date: Wed, 22 Jul 2009 15:56:15 -0400
Message-ID: <20090722155615.ade61dd4.wmoran@potentialtech.com> (raw)
In-Reply-To: <07E5D103-2E8F-48EE-868E-8DAD10BE0C80@indiana.edu>
References: <889FC92A-B6F2-4276-BFD7-E0061ACC73B6@indiana.edu>
<20090722152938.402f6228.wmoran@potentialtech.com>
<07E5D103-2E8F-48EE-868E-8DAD10BE0C80@indiana.edu>
In response to Carol Walter <walterc@indiana.edu>:
>
> On Jul 22, 2009, at 3:29 PM, Bill Moran wrote:
>
> > In response to Carol Walter <walterc@indiana.edu>:
> >
> >> Does pg_query_params return a false if an item is not found in a
> >> database?
> >
> > What's an item? That term is does not describe any type of standard
> > database object.
> >
> > pg_query_params() will return false if the query was invalid for any
> > reason. One such possible reason is that you tried to access a
> > table that doesn't exist.
> >
> > If you're getting false as the return value, you should use
> > pg_last_error() to discover the details of the error.
> No, I mean if I select select a name from the database but the name
> isn't found. I'm doing a log in form. I want to check to see if the
> user that's logging in exists in my database. I can check the number
> of rows returned or something like that, but I wondered if the
> function returns a false.
Please don't top-post.
I assume that (for some reason) you're avoiding using the term "table"
and that you're running a select query against a table and finding that
a particular row is or is no in that table?
If that's correct, you should work on communicating more clearly. Also,
if that is correct, I already answered your question:
"pg_query_params() will return false if the query was invalid for any
reason."
Meaning, "no, it won't return false if a matching row isn't found, because
the query was still valid."
--
Bill Moran
http://www.potentialtech.comhttp://people.collaborativefusion.com/~wmoran/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: wmoran@potentialtech.com, walterc@indiana.edu
Subject: Re: pg_query_params
In-Reply-To: <20090722155615.ade61dd4.wmoran@potentialtech.com>
References: <889FC92A-B6F2-4276-BFD7-E0061ACC73B6@indiana.edu> <20090722152938.402f6228.wmoran@potentialtech.com> <07E5D103-2E8F-48EE-868E-8DAD10BE0C80@indiana.edu> <20090722155615.ade61dd4.wmoran@potentialtech.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox