Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Class::DBI specifying field is NULL

by Fletch (Bishop)
on Jul 15, 2004 at 13:26 UTC ( [id://374641]=note: print w/replies, xml ) Need Help??


in reply to Class::DBI specifying field is NULL

Since it sits on top of Ima::DBI you could always define a custom search routine.

MyClass->set_sql( null_somefield => <<'EOT' ); SELECT __ESSENTIAL__ FROM __TABLE__ WHERE somefield IS NULL EOT my $iter = MyClass->search_null_somefield( );

Update: Ooh, looks like passing undef as is suguested below works fine (it gets translated into field IS NULL correctly). Strange they don't explicitly mention that in the docs or on the Class::DBI wiki.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://374641]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (7)
As of 2024-04-14 14:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found