I don't know what SQLField() means, I use Field() instead.
The variable loginsession is defined at the python level. SQL level will
nothing know about it.
So you run really the SQL command: "SELECT ... WHERE login=loginsession;".
Try same command in MySQL manager, it will not work because loginsession is
unkown.
Do you really need run raw SQL commands (with .executesql())?
Isn't better way use a DAL abstraction language like
dbRH(dbRH.test.id>0).select()
or
dbRH(dbRH.test.login=="Laurent").select()
?
Dne středa 16. září 2015 12:34:09 UTC+2 Laurent Lc napsal(a):
>
> Hi
> could you explain me why it does not work :
> my file db.py (a part of file)
>
> loginsession = auth.user.username
> dbRH = DAL('mysql://xxx:xxx@localhost/RH', pool_size=0)
> dbRH.define_table('test',
> SQLField('login', type = 'string' , length = 20 ),
> SQLField('nom', type = 'string' , length = 20 ),
> SQLField('prenom', type = 'string' , length = 20 ),
> SQLField('groupe', type = 'string' , length = 15 ),
> SQLField('mail', type = 'string' , length = 50 ),
> migrate = False)
> query='SELECT * from test WHERE login=loginsession'
> firstname =dbRH.executesql(query,as_dict=True)
>
> If i replace the var loginsession by "toto", it works and the var
> loginsession has a value ...
>
> Another question about DAL if i follow the doc :
> #q=dbRH.test.login==loginsession
> #s=db(q)
> #rows=s.select()
> #for row in rows:
> # prenom = row.prenom
>
> does not run too ...
>
>
> Thank you in advance
> Regards,
>
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
