Thanks for noting it, now I am passing the user id as part of pvars of the
task but with not much progress, though
If I run that query I get an empty list: []
El lunes, 3 de octubre de 2016, 12:01:22 (UTC-5), Anthony escribió:
>
> Note, auth.user_id will be None in the shell.
>
> What happens if you do (note the ._select rather than .select):
>
> db.executesql(db(db.my_table.logged_user == 1)._select())
>
> Anthony
>
> On Monday, October 3, 2016 at 12:40:09 PM UTC-4, Bernardo Leon wrote:
>>
>> I load my application in this way:
>> $ python web2py.py -M -S myexistingapp
>>
>>
>> if I run:
>>
>> db(db.my_table.logged_user == auth.user_id).select()
>>
>> I get: <Rows (0)>
>>
>> even if I run:
>>
>> db(db.my_table.logged_user == 1).select()
>>
>> or
>>
>> db(db.my_table.logged_user == 1L).select()
>>
>> I get: <Rows (0)>
>>
>> but if I run:
>>
>> db.executesql('select * from my_table where logged_user = 1;')
>>
>> I get my list of rows.
>>
>> Why is this happening? I found this issue because I was getting <Rows
>> (0)> on my scheduler.py task.
>>
>> Thanks in advance for any help I get with this issue.
>>
>>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
