[web2py] Re: empty record (data) set

2011-03-13 Thread Adnan S.
Just tested _select(). Thanks for that :) It is overwhelming, but I love this framework, so thoughtful and well done!!! And I haven't even scratched the surface yet :) On Mar 12, 8:50 pm, villas villa...@gmail.com wrote: By using the underscore in front of select, you can see the SQL. That

[web2py] Re: empty record (data) set

2011-03-12 Thread Adnan S.
Thanks Vasile! I'm making baby steps here :) On Mar 12, 5:15 pm, Vasile Ermicioi elff...@gmail.com wrote: 1==0 is a boolean not a query, empty_result = db(db.prod.id0).select() # I suppose that you don't have negative ids :)

[web2py] Re: empty record (data) set

2011-03-12 Thread villas
By using the underscore in front of select, you can see the SQL. That is often the best way to see what's going on... e.g. db(db.prod.id0)._select() On Mar 13, 12:37 am, Adnan S. adnan.smajlo...@gmail.com wrote: Thanks Vasile! I'm making baby steps here :) On Mar 12, 5:15 pm, Vasile Ermicioi