Hi, Below are the DAL query and its SQLite version, the bold expression was always 1 (true) which made me think its not working?
recs = db(m.mt_account==184901310)(*m.name[:2] in ['cr','bu','se']*)(m.writetime >lastupdate)(m.name[-4:]=='LOTs').select( m.mt_account,m.name,'ROUND(SUM(m.searchvalue),2)',m.writetime,groupby=m.name[2:8]) SELECT m.mt_account, m.name, ROUND(SUM(m.searchvalue),2), m.writetime FROM any info AS m WHERE ((((m.mt_account = 184901310) AND (m.writetime > '2014-07-02 13: 13:56')) AND (SUBSTR(m.name,(LENGTH(m.name) - 3),LENGTH(m.name)) = 'LOTs')) AND *1*) GROUP BY SUBSTR(m.name,3,(9 - 3)); -- 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.
