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.