> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Within the where clause of the query that is prepared...' > > where foo = ? > > When binding an undef value when executing, this executes "where foo = > NULL". One solution, though ugly, is: where ((? is null and foo is null) or foo = ?) You might want to check the query plan to see if the optimizer is still able to use any index that might exist on foo... HTH, Douglas Wilson