Re: Inserting NULL values with pymssql

2008-02-21 Thread Steve Holden
Jayson Barley wrote: > I am attempting to insert NULL values into a database. I have tried to > do this in multiple ways without any success, see below, and haven't > been able to find anything through Google to help out. I am hoping that > I am just overlooking something or that it is a rookie

RE: Inserting NULL values with pymssql

2008-02-21 Thread Jayson Barley
I also forgot to mention that this... import pymssql TestDB = pymssql.connect(host='Test',user='test',password='test',database='test') cursor = TestDB.cursor() query = """INSERT INTO test.dbo.test (test) VALUES ('%s');""" cursor.execute(query,(None)) works. While import pymssql TestDB =