exception thrown NULL value in parameter dictonary for INSERT

denisenkom / pytds

Python DBAPI driver for MSSQL using pure Python TDS (Tabular Data Stream) protocol implementation

MIT License

192 stars 53 forks source link

Closed bylsmad closed 6 years ago

bylsmad commented 7 years ago

setting a named parameter to NULL results in exception:

ok, so this is working for me now by using %s in the query and a tuple for the parameter values

I'm still not understanding how it is supposed to work with using a dictionary for parameters

Please provide sample code of cursor.execute(sql, parameters) where parameters is a dictionary

denisenkom commented 6 years ago

Can you provide failing example?