http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=multiple%20equivalent
On Wednesday, November 13, 2013 10:15:27 PM UTC+1, Noah Corradin wrote: > > Thank you so much! was this covered in some documentation i may have > missed? > > On Wednesday, November 13, 2013 8:51:06 AM UTC-8, Niphlod wrote: >> >> because db.table.field is NOT a string. >> >> statA = request.vars.stat1 >> order='db.allstats.'+statA >> >> should be >> >> statA = request.vars.stat1 >> order=db.allstats[statA] >> >> On Wednesday, November 13, 2013 3:32:20 AM UTC+1, Noah Corradin wrote: >>> >>> can someone explain to me why the following does not perform the way i >>> thought it would.... >>> >>> This works: >>> results=db(db.allstats.ptype==ptype).select(db.allstats.ALL, >>> orderby=db.allstats.attack) >>> >>> But this does not: >>> >>> statA = request.vars.stat1 >>> order='db.allstats.'+statA >>> >>> results = db(db.allstats.ptype==ptype).select(db.allstats.ALL, >>> orderby=order) >>> >>> i receive: uknown column 'db.allstats.attack' >>> >>> i've built selects using variables but i cant build orderby with >>> variables? any tips would be awesome. >>> >> -- 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.
