web2py users,
I'm using pyodbc, unixodbc and freetds to hit an MSSQL database.
When I attempt to do a:
a_sample_inventory = db(db.smp_inventory.smp_id ==
request.vars.smp_id).select()
a_sample_inventory[0].update_record(status="present")
I get:
Traceback (most recent call last):
File "/home/larsenma/web2py/gluon/restricted.py", line 62, in
restricted
File "/usr/share/web2py/applications/hpv/controllers/home.py", line
45, in <module>
File "/home/larsenma/web2py/gluon/globals.py", line 55, in <lambda>
File "/usr/share/web2py/applications/hpv/controllers/home.py", line
40, in unreserve
db(a_sample_history[0]).delete()
File "/usr/share/web2py/gluon/sql.py", line 1110, in delete
self._db._execute(query)
File "/usr/share/web2py/gluon/sql.py", line 448, in <lambda>
self._execute=lambda *a,**b: self._cursor.execute(*a,**b)
ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Incorrect
syntax near '<'. (102) (SQLExecDirectW)")
I looked at the generated sql statement and it looks fine.
And ideas what's going on?
Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
