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 1025fixture_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]
