[web2py] Re: 2.4.2 breaks query

2013-03-06 Thread Niphlod
open an issue with a model and the query to reproduce .. so it gets tracked (and fixed) On Thursday, March 7, 2013 12:30:16 AM UTC+1, chicks wrote: > > Changed to this to fix: > > fields = db.projects.prj_type,db.projects.prj_name, \ > db.projects.prj_environment,db.projects.prj_zon

[web2py] Re: 2.4.2 breaks query

2013-03-06 Thread chicks
Changed to this to fix: fields = db.projects.prj_type,db.projects.prj_name, \ db.projects.prj_environment,db.projects.prj_zone, \ db.projects.prj_host,db.projects.prj_port, \ db.projects.prj_instance,db.projects.prj_app_type, \ db.projects.prj_application, \ db.projects.pr

[web2py] Re: 2.4.2 breaks query

2013-03-06 Thread Derek
No idea why you are getting that _extra. It's supposedly not matching the "regex_table_field" Anyway, when I do a select, and I want specific columns, I do it like so... rows = db( query ).select(db.projects.prj_type,db.projects.prj_name,db.projects.prj_environment,db.projects.prj_zone, db.p

[web2py] Re: 2.4.2 breaks query

2013-03-06 Thread chicks
So, it works fine if I leave out the "fields" filter, but, of course, returns ALL the fields, which is unwanted... Do I now need to rename the fields definitions somehow? fields = db.projects.prj_type|db.projects.prj_name| \ db.projects.prj_environment|db.projects.prj_zone| \ db.pr