[web2py] Re: Is it a bug in "with_alias"?

2011-01-10 Thread LightOfMooN
oops, sorry, failed with spaces "^" is under "AS", not under "FROM"

[web2py] Re: Is it a bug in "with_alias"?

2011-01-10 Thread Massimo Di Pierro
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 wrote: > rolics = db(db.rolic.id>0).select(db.rolic.id.with_alias('myid')) > > Traceback (mos

[web2py] Re: Is it a bug in "with_alias"?

2011-01-11 Thread LightOfMooN
Is there an other way to query field rennamed? On 11 янв, 03:17, Massimo Di Pierro 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, Light