How does one search for null values?

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

From: Alexander Karelas
Subject: How does one search for null values?
Date: 13:32 on 04 May 2004

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.


Thanks,
Alex

How does one search for null values?
Alexander Karelas 13:32 on 04 May 2004

Re: How does one search for null values?
colm-cdbi 13:59 on 04 May 2004

Generated at 11:34 on 01 Dec 2004 by mariachi v0.52