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.projects.prj_host|db.projects.prj_port| \ db.projects.prj_instance|db.projects.prj_app_type| \ db.projects.prj_application| \ db.projects.prj_dbhost|db.projects.prj_dbinstance #rows = db( query ).select(fields, orderby=orderby) # NOT WORKING rows = db( query ).select(orderby=orderby) # Works, BUT...
On Wednesday, March 6, 2013 11:11:14 AM UTC-8, chicks wrote: > Been running on 2.0.9 for some time, trying to update to 2.4.2, but some > query returns have changed, breaking SQLTABLE() attempt. > > An Oracle query that returns this on 2.0.9: > <Row {'prj_zone': 'ETGA1', 'prj_app_type': 'ANI', 'prj_instance': 'ani', > 'prj_name': 'ETGA', 'prj_host': 'ZUATAPP6', 'prj_application': 'ANI', > 'prj_environment': 'MNF', 'prj_dbhost': 'uatdb3', 'prj_dbinstance': > 'gamnf', 'prj_type': 'ET', 'prj_port': None}> > returns this on 2.4.2, which breaks SQLTABLE(): > <Row {'_extra': {'projects.prj_type, projects.prj_name, > projects.prj_environment, projects.prj_zone, projects.prj_host, > projects.prj_port, projects.prj_instance, projects.prj_app_type, > projects.prj_application, projects.prj_dbhost, projects.prj_dbinstance': > 'ET'}}> > What's up with the "_extra"??? > > Thanks, > > Chuck > -- --- 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.