On Nov 15, 2007 6:03 PM, Ash Berlin <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
>
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
_______________________________________________
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/[EMAIL PROTECTED]
