Without this clause the query does not work at all. In shown case it
works in mysql and sqlite.
On Oct 12, 6:11 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> I think there is something wrong with the query:
>
> groupby=db.carts.ALL
>
> is not allowed.
>
> Massimo
>
> On Oct 12, 8:45 am, SergeyPo <ser...@zarealye.com> wrote:
>
>
>
> > The following statement gives strange error with Oracle. This has
> > something to do with oracle_fix in gluon/sql.py
>
> > many_to_many = (db.c_h.cart_id==db.carts.id)
> > db(db.carts.id>0).select(db.carts.ALL, db.c_h.cart_id.count(),
> > left=db.c_h.on(many_to_many),
> > groupby=db.carts.ALL,
> > orderby=carts_orderby,
> > limitby = session.carts_limitby)
>
> > Traceback (most recent call last):
> > File "C:\web2py\gluon\restricted.py", line 176, in restricted
> > exec ccode in environment
> > File "C:\web2py\applications\advantage/controllers/cart.py", line
> > 164, in <module>
> > File "C:\web2py\gluon\globals.py", line 103, in <lambda>
> > self._caller = lambda f: f()
> > File "C:\web2py\applications\advantage/controllers/cart.py", line
> > 13, in new_cart
> > carts, search_form, pages = prepare_carts_table('filter_by_cart')
> > File "C:\web2py\applications\advantage/controllers/cart.py", line
> > 158, in prepare_carts_table
> > limitby = session.carts_limitby),
> > File "C:\web2py\gluon\sql.py", line 2146, in select
> > r = response(query)
> > File "C:\web2py\gluon\sql.py", line 2141, in response
> > self._db._execute(query)
> > File "C:\web2py\gluon\sql.py", line 777, in <lambda>
> > oracle_fix_execute(a,self._cursor.execute)
> > File "C:\web2py\gluon\sql.py", line 471, in oracle_fix_execute
> > return execute(command[:-1], args)
> > DatabaseError: ORA-00979: not a GROUP BY expression
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
