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.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,orderby=orderby)
On Wednesday, March 6, 2013 3:27:21 PM UTC-7, chicks wrote:
>
> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
