[Dbix-class] '' != NULL for great sadness

Ryan Cone metrext at gmail.com
Thu Jul 9 15:08:07 GMT 2009


NULL is not the same as '' (blank) in MSSQL.  The database is  
complaining that it cannot cast '' to an integer.

If you want to set it to NULL, then you can't set it to blank.

-Ryan

On Jul 9, 2009, at 11:00 AM, fREW Schmidt wrote:

>
>
> On Thu, Jul 9, 2009 at 9:36 AM, Mike South <msouth at gmail.com> wrote:
> First thing I would try is going to
>
> http://search.cpan.org/~timb/DBI/DBI.pm
>
> search page for NULL, see if that helps.
>
> I looked through it and didn't see anything.  Someone told me it is  
> a function of the DBD so I am looking through DBD::ODBC, but so far,  
> no luck.
>
> -- 
> fREW Schmidt
> http://blog.afoolishmanifesto.com
> _______________________________________________
> 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.scsys.co.uk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20090709/7d728a5d/attachment.htm


More information about the DBIx-Class mailing list