Re: How does one search for null values?

[prev] [thread] [next] [Date index for 2004/05/04]

On Tue, May 04, 2004 at 04:32:12PM +0300, Alexander Karelas wrote:
> I need to search a table for records with field1 IS NULL.
> 
> Is there a way to do this with the search method of my table's class?
> I tried Class->search(field1 => undef) and search(field1 => '') but 
> neither would return the records I'm interested in.

search() can only do this as of the latest version (0.96).  The syntax
is a per your first (undef) attempt.

Colm