<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">NULL is not the same as '' (blank) in MSSQL. The database is complaining that it cannot cast '' to an integer. <div><br></div><div>If you want to set it to NULL, then you can't set it to blank.</div><div><br></div><div>-Ryan</div><div><div><br><div><div>On Jul 9, 2009, at 11:00 AM, fREW Schmidt wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><br><br><div class="gmail_quote">On Thu, Jul 9, 2009 at 9:36 AM, Mike South <span dir="ltr"><<a href="mailto:msouth@gmail.com">msouth@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> First thing I would try is going to<br> <br> <a href="http://search.cpan.org/%7Etimb/DBI/DBI.pm" target="_blank">http://search.cpan.org/~timb/DBI/DBI.pm</a><br> <br> search page for NULL, see if that helps.<br> </blockquote><div> </div></div>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.<br clear="all"><br>-- <br>fREW Schmidt<br> <a href="http://blog.afoolishmanifesto.com">http://blog.afoolishmanifesto.com</a><br> _______________________________________________<br>List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>IRC: irc.perl.org#dbix-class<br>SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a></blockquote></div><br></div></div></body></html>