OK, so I re-wrote the queries involving distinct so that I just
iterate over the recordsets and create my own array with distinct
values.
But I'm still getting an error about distinct. I've 'cleaned' the app
in case the old code is causing this.
Here's the error:
ERROR 2009-09-05 03:37:26,473 restricted.py:58] In FILE: U:\icoexist
\web2py\applications\init/views/default/user.html
Traceback (most recent call last):
File "U:\icoexist\web2py\gluon\restricted.py", line 178, in
restricted
exec ccode in environment
File "U:\icoexist\web2py\applications\init/views/default/user.html",
line 30, in <module>
i=1
File "U:\icoexist\web2py\gluon\contrib\gql.py", line 658, in select
(items, tablename, fields) = self._select(*fields, **attributes)
File "U:\icoexist\web2py\gluon\contrib\gql.py", line 600, in _select
raise SyntaxError, 'invalid select attribute: %s' % key
SyntaxError: invalid select attribute: distinct
I can't even find the word 'distinct' in my controllers or my views.
Thanks for any help.
On Sep 4, 3:58 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> no that I know.
>
> On Sep 4, 2:05 pm, Derek <cunningh...@gmail.com> wrote:
>
>
>
> > Hi all,
>
> > I deployed my web2py app to GAE, and received the following error:
>
> > SyntaxError: invalid select attribute: distinct
>
> > If using web2py's default arguments to get distinct values is not
> > valid on GAE, is there any other way?
>
> > Thanks,
>
> > Derek
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---
