sorry. orderby not _orderby
On Dec 1, 1:45 am, SergeyPo <[EMAIL PROTECTED]> wrote:
> I also thought so but here is what happens:
>
> File "/Users/vasilina/Documents/Development/ADVANTAGE/web2py/
> applications/advantage/controllers/radar.py", line 37, in data_storage
> time_based_details = db(db.time_based.PIN==record.PIN).select
> (_orderby=db.time_based.ca_date, *full_qualifiers)
> File "/Users/vasilina/Documents/Development/ADVANTAGE/web2py/gluon/
> sql.py", line 1132, in select
> query=self._select(*fields,**attributes)
> File "/Users/vasilina/Documents/Development/ADVANTAGE/web2py/gluon/
> sql.py", line 1067, in _select
> raise SyntaxError, 'invalid select attribute'
> SyntaxError: invalid select attribute
>
> It takes fields for selection only if they are * at first position.
>
> On Nov 30, 7:29 pm, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > * and ** parameters have to be last:
>
> > time_based_details = db().select
> > (_orderby=db.time_based.ca_date,*full_qualifiers)
>
> > On Nov 30, 4:04 am, SergeyPo <[EMAIL PROTECTED]> wrote:
>
> > > Hello!
>
> > > This is probably Python question, but maybe you can help:
> > > I need to prepare the list of fields to be selected from DB
> > > programmatically:
>
> > > full_qualifiers = [] #list of SQLTABLE fields
> > > time_based_details = db().select(*full_qualifiers,
> > > _orderby=db.time_based.ca_date)
>
> > > But Python does not allow me to use both * and named parameter in one
> > > function call. This works:
>
> > > time_based_details = db().select(*full_qualifiers)
>
> > > but I need to sort data according to date.
>
> > > Thank you in advance!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
