My guest is the alias name 'group', have you already tried with a different name?
Paolo On Sunday, December 21, 2014 1:34:21 AM UTC+1, Manuele wrote: > > I get this traceback error: > > Traceback (most recent call last): > File "/home/manuele/web2py/gluon/restricted.py", line 224, in restricted > exec ccode in environment > File > "/home/manuele/web2py.trunk/applications/theseus2/models/dashboard/dashboard.py", > line 158, in <module> > requires = IS_EMPTY_OR(IS_IN_SET(toposet(), multiple=True)), > File > "/home/manuele/web2py.trunk/applications/theseus2/models/dashboard/dashboard.py", > line 74, in toposet > orderby = ora.municipio.cod > File "/home/manuele/web2py/gluon/dal/objects.py", line 2064, in select > return adapter.select(self.query,fields,attributes) > File "/home/manuele/web2py/gluon/dal/adapters/base.py", line 1231, in select > return self._select_aux(sql,fields,attributes) > File "/home/manuele/web2py/gluon/dal/adapters/base.py", line 1196, in > _select_aux > self.execute(sql) > File "/home/manuele/web2py/gluon/dal/adapters/oracle.py", line 136, in > execute > return self.log_execute(command, args) > File "/home/manuele/web2py/gluon/dal/adapters/base.py", line 1312, in > log_execute > ret = self.cursor.execute(command, *a[1:], **b)DatabaseError: ORA-00923: > FROM keyword not found where expected > > > and near line 74 of file I got this select definition: > > mres = ora(ora.municipio.id>0).select( > ora.municipio.ALL, > """municipio AS "table" """, > """Municipio AS "group" """, > orderby = ora.municipio.cod > ).as_list() > > and it generates the subsequent raw query code: > > "SELECT municipio.id, municipio.cod, municipio.roman_cod, > municipio.odonimo, 'municipio' AS table, 'Municipio' AS group FROM > municipio WHERE (municipio.id > 0) ORDER BY municipio.cod;" > > Unfortunately I got no experience with Oracle db. I developed my > application till now using PostgreSQL but now I need to switch to Oracle. > Can some body help me to debug this problem? > > Thank you very mutch > > Manuele > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
