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

Ash Berlin ash_cpan at firemirror.com
Thu Nov 15 12:33:05 GMT 2007


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?



More information about the DBIx-Class mailing list