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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.