Hi,
I don't see where the orderby is being added - based on the traceback
it looks like from a validator, but i learned that on GAE orderby
can't be a string. i have some of my own forms for viewing and
editing data, and they convert orderby so it works on GAE:
@auth.requires_login()
def art_type():
form = SQLFORM(db[request.function])
if request.args and request.args[0]:
form = SQLFORM(db[request.function], request.args[0])
if form.accepts(request.vars, session):
redirect(URL(r=request, f=request.function))
#for GAE the orderby must already be a table field, not a string,
so convert
orderby=None
if request.vars.orderby:
(table, field) = request.vars.orderby.split(".")
orderby=db[table][field]
rows = db(db[request.function].id>0).select(orderby=orderby)
tbl = SQLTABLE(rows,linkto,orderby=True,_class='sortable',
truncate=128)
return dict(form=form, rows=tbl,
aahome=A("Forms Home", _href=URL(r=request,
f='index')))
so i guess you need to track down which validator is doing that and
specify the order by explicitly? hope that helps. and good luck!
cfh
On May 5, 1:08 pm, Leandro - ProfessionalIT <[email protected]>
wrote:
> Friends,
>
> Another information....locally with SQLite works perfectly, but in
> the GAE these errors happening.
>
> Any Idea ?
