Is there an other way to query field rennamed?
On 11 янв, 03:17, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> Actually I am not sure why the SQL is wrong. The SQL looks correct
> although with_alias for a field is undocumented, except for tables,
> and I am not sure how well it works.
>
> On Jan 10, 3:42 pm, LightOfMooN <vladsale...@yandex.ru> wrote:
>
>
>
>
>
>
>
> > rolics = db(db.rolic.id>0).select(db.rolic.id.with_alias('myid'))
>
> > Traceback (most recent call last):
> > File "/home/www-data/web2py/gluon/contrib/shell.py", line 225, in
> > run
> > exec compiled in statement_module.__dict__
> > File "<string>", line 1, in <module>
> > File "/home/www-data/web2py/gluon/dal.py", line 4507, in select
> > return self.db._adapter.select(self.query,fields,attributes)
> > File "/home/www-data/web2py/gluon/dal.py", line 1003, in select
> > rows = response(sql)
> > File "/home/www-data/web2py/gluon/dal.py", line 994, in response
> > self.execute(sql)
> > File "/home/www-data/web2py/gluon/dal.py", line 1067, in execute
> > return self.log_execute(*a, **b)
> > File "/home/www-data/web2py/gluon/dal.py", line 1064, in log_execute
> > return self.cursor.execute(*a,**b)
> > ProgrammingError: syntax error at or near "AS"
> > LINE 1: SELECT (rolic.id AS myid) FROM rolic WHERE (rolic.id > 0);
> > ^
>
> > What's wrong? Help, please.
