The following code works fine in 1.79.2 but gives an error in 1.91.6. Any
ideas?
tntdb = SQLDB(tnt_connection_string) #this connects to MS SQL Server
tntdb.define_table('Employees',
Field('employeeID', 'id'),
Field('firstName', length=20),
Field('networkUsername'),
Field('isManager', 'boolean'), #isManager has type BIT in the database
migrate=False)
def _find_user_by_name(username):
return tntdb((tntdb.Employees.networkUsername == username) &
(tntdb.Employees.isManager == True)).select()
Calling _find_user_by_name() works fine in 1.79.2 but gives the following
error in 1.91.6:
Thread-11 2011-01-03 17:34:32,289 ERROR login() Traceback (most recent call
last):
File "c:\web2py\applications\scandabamc/controllers/default.py", line 129,
in login
user = _find_user_by_name(request.vars.username)
File "c:\web2py\applications\scandabamc/controllers/default.py", line 164,
in _find_user_by_name
return tntdb((tntdb.Employees.networkUsername == username) &
(tntdb.Employees.isManager == True)).select()
File "c:\web2py\gluon\dal.py", line 4507, in select
return self.db._adapter.select(self.query,fields,attributes)
File "c:\web2py\gluon\dal.py", line 1003, in select
rows = response(sql)
File "c:\web2py\gluon\dal.py", line 994, in response
self.execute(sql)
File "c:\web2py\gluon\dal.py", line 1067, in execute
return self.log_execute(*a, **b)
File "c:\web2py\gluon\dal.py", line 1064, in log_execute
return self.cursor.execute(*a,**b)
DataError: ('22018', "[22018] [Microsoft][ODBC SQL Server Driver][SQL
Server]Conversion failed when converting the varchar value 'T' to data type
bit. (245) (SQLExecDirectW)")
