[Dbix-class] search syntax for null values in dbix

[jagdish eashwar]

On Nov 15, 2007 6:03 PM, Ash Berlin <ash_cpan at firemirror.com> wrote:
>
> jagdish eashwar wrote:
> > Hi,
> >
> > I haven't been able to find the exact syntax for searching null values
> > either in the documentation or on google. I tried :
> > @myarray = $schema->resultset('model')->search({fieldname => undef})
> > but it didn't retrieve any row although there are matching rows in the table.
> >
> > jagdish eashwar
> >
> >
> That looks right. what sql does DBIC_TRACE show?
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.rawmode.org
>

Thanks. Emboldened by your reply, I checked my test script again. I
found that I had commented out the print statement. I'm sorry.

jagdish eashwar