#33 Fix for svn trunk mssqlconnection.py

closed-accepted
nobody
None
5
2006-01-06
2005-12-09
Michael Baltaks
No

Connecting to MS SQL Server 2000 sp3a from Windows 2000 using
current 2005-12-09 svn trunk SQLObject via pymssql 0.7.3 I needed to
use this patch:

=============================================

--- mssqlconnection.py (revision 1383)
+++ mssqlconnection.py (working copy)
@@ -70,7 +70,7 @@
cur = con.cursor()
cur.execute('SET ANSI_NULLS ON')
cur.execute("SELECT CAST('12345.21' AS DECIMAL(10, 2))")
- self.decimalSeparator = cur.fetchone()[0][-3]
+ self.decimalSeparator = str(cur.fetchone()[0])[-3]
cur.close()
return con

Discussion

  • Oleg Broytman
    Oleg Broytman
    2006-01-06

    • status: open --> closed-accepted
     
  • Oleg Broytman
    Oleg Broytman
    2006-01-06

    Logged In: YES
    user_id=4799

    Applied at the revision 1476. Thank you!