pymssql - insert NULL to int
Diez B. Roggisch
deets at nospam.web.de
Thu Oct 18 17:04:54 CEST 2007
> On Oct 17, 11:07 am, "Diez B. Roggisch" <de... at nospam.web.de> wrote:
>> rc wrote:
>> > How to insert NULL values in to int field using params.
>> > I'm trying to use pymssql.execute, passing the operation and list of
>> > params. One of the values in the params is a NULL value going to int
>> > field. The pymssql._quote() puts ' around the NULL which causes an
>> > exception to be thrown, is there a way to use the params for this or
>> > do I need to build the insert string myself?
>> > pymssql.DatabaseError: internal error: SQL Server message 245,
>> > severity 16, state 1, line 1:
>> > Conversion failed when converting the varchar value 'NULL' to data
>> > type int.
>> > DB-Lib error message 10007, severity 5:
>> > General SQL Server error: Check messages from the SQL Server.
>> Can you show us the actual code you use? I doubt that such a basic thing
>> isn't working.
>> You are aware that you have to pass None, not "NULL"?
> I had tried None and was getting the same error as 'NULL', however, I
> tried again after your post and its working now. Not sure what I
> changed but thanks for getting me to tried it again.
I'm pretty sure you tried "None" instead of None
More information about the Python-list