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'

Reply via email to