[Catalyst] not null search - DONE

[Will Smith]

Thanks Chris,
  I got the answer from the link you post:
   
  my $sql = 'is not null';

   my @rows = Some::CDBI->search_where(
      some_column => \$sql
   );
   
  Regards,

"Christopher H. Laco" <claco at chrislaco.com> wrote:
  Will Smith wrote:
> Hi, 
> first, thanks for all of your help.
> A simple question I want to ask is how to do a search for NOT NULL value. I do not want to use ->search_like
> 
> Thank you

On what Model? A DBIC based Model?

{column => {'!=', undef} I'd assume...

-=Chris

_______________________________________________
List: Catalyst at lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/


 
---------------------------------
Sucker-punch spam with award-winning protection.
 Try the free Yahoo! Mail Beta.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20070215/eaaae61e/attachment.htm