http://qs321.pair.com?node_id=374616

inblosam has asked for the wisdom of the Perl Monks concerning the following question:

What I am trying to do seems it should be quite simple. I am using Class::DBI and am trying to do a search to find entries that have a particular field as NULL.
my @listings = Table::Listings->search(somefield=>'NULL');
This doesn't work, and neither does everything else I have tried to think of. I tried retrieve_from_sql but for some reason that is giving me problems, and I figure there is a way to get this to work...if I just knew how!! I looked around here, google, Class::DBI pod...but nothing. -Michael