I can't find this in the docs, but I'm wondering how I go about an 'is not null' search. Currently, if I want to figure out which operating systems have a vlan they can install from, I want to select all operating systems whose install_vlan is not null. The closest I can figure out from Rose is this:
my $operating_systems = OS::Manager->get_os( query => [ install_vlan => { like => '%' } ], ); Is there a more correct way of doing this other than using SQL directly? Cheers, Ovid -- Buy the book -- http://www.oreilly.com/catalog/perlhks/ Perl and CGI -- http://users.easystreet.com/ovid/cgi_course/ ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object