Home Original page

pymssql - insert NULL to int

Diez B. Roggisch deets at nospam.web.de
Thu Oct 18 11:04:54 EDT 2007 
rc wrote:

> 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"?
>>
>> Diez
> 
> 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

Diez
More information about the Python-list mailing list