i'm having problems with this funtión
rows=dbib().select(dbib.Convenios.ALL)
Data base def
import pyodbc
dbib=DAL('mssql://user:passw...@databaseserver/database?
DRIVER={FreeTDS}')
in controller:
def convenios():
rows=dbib().select(dbib.Convenios.ALL) # if I use this it dosen't
works...
#rows=dbib.executesql('SELECT * FROM Convenios;') # if I use this
it works...
return dict(Datos=rows)
Error detail:
Error traceback
Traceback (most recent call last):
File "/home/administrador/web2py/gluon/restricted.py", line 188, in
restricted
exec ccode in environment
File "/home/administrador/web2py/applications/init/controllers/
default.py", line 68, in <module>
File "/home/administrador/web2py/gluon/globals.py", line 96, in
<lambda>
self._caller = lambda f: f()
File "/home/administrador/web2py/applications/init/controllers/
default.py", line 65, in convenios
rows=dbib().select(dbib.Convenios.ALL)
File "/home/administrador/web2py/gluon/sql.py", line 1380, in
__getattr__
return dict.__getitem__(self,key)
KeyError: 'Convenios'