pymssql 1.02 help!

[Joo]

in my application i install web.py 0.32 DBUtils 1.0 and pymssql 1.02
write some code:
    db = web.database(dbn='mssql', host='192.168.214.130', db='master', user='sa', pw='ca0zh0ng')
    db.select('sysdatabases', where='dbid > 6')
take some errors:
    'params' arg can be only a tuple or a dictionary.
    Python /var/lib/python-support/python2.6/pymssql.py in execute, line 191
    Web GET http://localhost:8080/

    Variable Value
    args ([],)
    operation 'SELECT * FROM sysdatabases WHERE dbid > 6'
    self <pymssql.pymssqlCursor object at 0x2966710>

[kindy (kindy61)]

i got this error too.

i just fix this by change the web.db module.

code at http://github.com/kindy61/webpy/commit/b57219294e48f5cb8460d7d16c6221917b743283#L1R546
:)

[Anand Chitipothu (anandology)]

Looks like your change effects only insert queries. How will solve the problem of a SELECT query?

[Anand Chitipothu (anandology)]

Joo, please run the following and let me know what it gives.

db.query('SELECT * FROM sysdatabases WHERE dbid > 6')