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<[email protected]> 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/[email protected] > _______________________________________________ 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]
