Re: [GENERAL] prepared SELECT and placeholders with NULL values

2006-03-25 Thread Bruno Wolff III
On Thu, Mar 23, 2006 at 15:24:16 -0600, Michael Lea <[EMAIL PROTECTED]> wrote: > > $s = $db->prepare('SELECT id FROM person WHERE lname = ? AND fname = ?'); > > But this does not, returning an empty list: > $s->execute('Cher', undef); = NULL will return NULL for every row and no rows will

[GENERAL] prepared SELECT and placeholders with NULL values

2006-03-23 Thread Michael Lea
Hi, I'm having an issue using NULL values to fill placeholders in a prepared SELECT statement. My table looks something like this: CREATE TABLE person (id serial primary key, lname text not null, fname text); Given queries like this (using the Perl DBI+DBD::Pg interface): $i = $db->prepare('IN