GAE does not support upper, lower, and any manpulation of the fields in queries.
On Jan 12, 4:50 am, mattynoce <mattyn...@gmail.com> wrote: > i have an issue with upper and gae (separate from other orderby=upper > questions i've seen) i was hoping you could comment on. > > i have this line: > select(...orderby=(db.table.field.upper()) > > and when the select returns an empty set, it looks fine on web2py. > however, when the select returns an empty set on gae, i get the > following error: > TypeError: unsupported operand type(s) for %: 'NoneType' and 'dict' > > if i eliminate ".upper()" and change it to: > select(...orderby=(db.table.field) > > i get no error. is there anything i can do so that it doesn't try to > uppercase an empty field and error in gae? > > thanks, > > matt
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.