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

[Mike South]

First thing I would try is going to

http://search.cpan.org/~timb/DBI/DBI.pm

search page for NULL, see if that helps.

mike

On Thu, Jul 9, 2009 at 9:22 AM, fREW Schmidt<frioux at gmail.com> wrote:
> Hey guys,
>
> So I just ran into this yesterday.  I don't know how I didn't see it
> before.  Anyway, if I have a field that is a nullable integer I am told that
> '' should automatically be converted to a NULL.  MSSQL does this for me when
> I type the query directly into the Management Studio, but it doesn't when I
> am using DBIx::Class.  Here is the error I am getting:
>
> DBI Exception: DBD::ODBC::st execute failed: [Microsoft][SQL Native
> Client]Invalid character value for cast specification (SQL-22018) [for
> Statement "UPDATE QCParts SET fixture_id = ? WHERE ( id = ? )" with
> ParamValues: 1='', 2='001A215A1820000'] at c:/Documents and Settings/frew/My
> Documents/Code/aircraft_ducting/local/lib/DBIx/Class/Schema.pm line 1025
>
> fixture_id should be an integer.  Does anyone know what I can do to fix this
> issue?
>
> --
> 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
>