Bug 110410 – pymssql: Error raised on data insert/update using valid SQL statement

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description E A Faisal 2005-10-25 00:41:50 UTC]

When execute valid insert/update statement using standard Python DB API,
NameError and/or DatabaseError are raised unexpectedly. This will result in
failure to insert/update record.

Reproducible: Always
Steps to Reproduce:
Execute a valid insert/update statement using Python DB API.

Actual Results:  
NameError and/or DatabaseError are raised.

Expected Results:  
No errors should be catched by the module if the insert/update statement is
valid and any record being inserted/updated should be reflected in the database.

The bug can be solved if the following is added to  the beginning of pymssql.py:
import types, string

[Comment 1 Thomas Raschbacher 2005-12-06 17:28:36 UTC]

It seems that version 0.7.1 of pymssql is out already. have you tried it? (i'll
add it to portage shortly [need my new HDD first])

[Comment 2 E A Faisal 2005-12-06 18:08:15 UTC]

Yes, I've been testing version 0.7.1 for the past 2 weeks and it works great.
This bug (and a few more) is no longer evident in this newer version.

[Comment 3 Thomas Raschbacher 2005-12-17 20:12:10 UTC]

in ~arch