Archive for the 'DBIx::Class' Category

How to Write IS NOT NULL in DBIx::Class

Thursday, September 20th, 2007

I needed to write a query using DBIx::Class tonight that would return rows where a column wasn’t null. The first couple of ways I tried to didn’t work – here’s how to do it:

$result = $schema->resultset('RESULTSET')->search({ column => { '!=' => undef }});

(more…)

Sponsored Links

Warning: include(/home/romkey/cache/apocablog.html) [function.include]: failed to open stream: Permission denied in /web/bfr/www/blog.blueforestresearch.com/wp-content/themes/bfrblog2/leftbar.php on line 50

Warning: include() [function.include]: Failed opening '/home/romkey/cache/apocablog.html' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /web/bfr/www/blog.blueforestresearch.com/wp-content/themes/bfrblog2/leftbar.php on line 50

Warning: include(/home/romkey/cache/shinythings.html) [function.include]: failed to open stream: Permission denied in /web/bfr/www/blog.blueforestresearch.com/wp-content/themes/bfrblog2/leftbar.php on line 56

Warning: include() [function.include]: Failed opening '/home/romkey/cache/shinythings.html' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /web/bfr/www/blog.blueforestresearch.com/wp-content/themes/bfrblog2/leftbar.php on line 56