HI Martin,
I could not able to connect to database giving the below error.
Traceback (most recent call last):
File "/home/vikramt/web2py/gluon/restricted.py", line 188, in
restricted
exec ccode in environment
File "/home/vikramt/web2py/applications/myapp/controllers/
default.py", line 66, in <module>
File "/home/vikramt/web2py/gluon/globals.py", line 96, in <lambda>
self._caller = lambda f: f()
File "/home/vikramt/web2py/applications/myapp/controllers/
default.py", line 24, in check
roles=myrole.mysession(request.vars.ldap)
File "applications/myapp/modules/checkrole.py", line 4, in mysession
role=db.user(role,ldap=username)
NameError: global name 'db' is not defined
I have tried all sorts but could not. Could you please help me
Thanks
Vikram
On Dec 11, 4:27 pm, "Martin.Mulone" <[email protected]> wrote:
> checkrole.py
> -------------------
> class checkrole():
> def mysession(name):
> username=name
> role=db.user(role,ldap=username)
> return role
>
> db.py
> ---------
> db=SQLDB('mysql://root:test...@localhost/web')
> modrole=local_import('checkrole')
> myrole = modrole.checkrole()
> db.define_table('user',Field('ldap'),Field('role'))
>
> my controller
> -------------------
> def check():
> form=FORM(INPUT(_name='ldap',_type='text'),INPUT(_type='Submit'))
> if form.accepts(request.vars):
> return dict(roles=myrole.mysession(request.vars.ldap))
> return dict(form=form)
