On Oct 17, 11:07 am, "Diez B. Roggisch" <[EMAIL PROTECTED]> 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. rc -- http://mail.python.org/mailman/listinfo/python-list
