Good fix. In trunk. On Monday, 9 December 2013 22:08:53 UTC-6, Boris Aguilar wrote: > > Hi, using Web2py 2.8.1 and doing a query where you need to for example add > two values of a table to query data such as: > > table1 > ------------------------- > id | field1 | fIeld2 > ------------------------- > 1 | 1 | 2 > 2 | 3 | 5 > ... > > so i wanted to have all rows that (db.table1.field1 + db.table1.field2)>4 > I would just do db(((db.table1.field1 + db.table1.field2)>4)).select() > > But in 2.8.1 (as is the only version i've to test) that would result in an > incorrect: > > SELECT table1.id, table1.field1, table1.field2 FROM table1 WHERE > (CONCAT(CAST(db.table1.field1), CAST(db.table1.field2))>4); > > wich is not what i want. I want the standard addition in the SQL Statement > like: > > SELECT table1.id, table1.field1, table1.field2 FROM table1 WHERE > ((db.table1.field1 + db.table1.field2)>4); > > So i've changed Line 1431 of dal.py > -- if self.is_numerical_type(first.type): > ++ if self.is_numerical_type(first.type) or isinstance(first.type, > gluon.dal.Field): > > And that fixes it. > >
-- 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/groups/opt_out.
