I'm trying to allow people to select a column to sort by in t3.
{{=self.itemize0(db.qpac, query=request.vars._query or '' ,
orderby=request.vars._orderby or db.qpac.subject, nitems=12)}}
I have an html input hidden field call _orderby, but orderby likes the
actual db.qpac.subject and not a string from request.vars._orderby
since I keep getting:
File "/opt/web2py/gluon/sql.py", line 772, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: no such column: db.qpac.subject
I set the _orderby with a jqeury call and then submit the form with
the new sort field.
I can't seem to do db.qpac[0] to get at a field name either or I could
access the field via index. How do you also programmatically access
db.table.FIELDS?
thx,
-wes
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" 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
-~----------~----~----~----~------~----~------~--~---
