db.executesql("select * from test where latest = 'T';") or better
db(db.test.latest==True).select() On Wednesday, 19 February 2014 07:41:03 UTC-6, software.ted wrote: > > I have noticed in web2py boolean is represented in mysql as Char(1) when > boolean is defined in the DAL model as follow: > > db.define_table("test", Field("latest", "boolean")) > > mysql field shows as follows: latest char(1) > > when i test a query in mysql db.executesql("select * from test where > latest is true") is failing. > > Any ideas!? > > -- > > ....................................................................................... > Teddy Lubasi Nyambe > Opensource Zambia > Lusaka, ZAMBIA > > Cell: +260 97 7760473 > website: http://www.opensource.org.zm > > ~/ > Human Knowledge belongs to the world! - AntiTrust > > Man is a tool-using animal. Without tools he is nothing, with tools he is > all - Thomas Carlyle 1795-1881 > > /~ > -- 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/groups/opt_out.