[web2py] Re: orderby variable, uknown column
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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: orderby variable, uknown column
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.
[web2py] Re: orderby variable, uknown column
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.