Hey:
I just started using web2py a few weeks ago and I love it..
Congratulations for the great work.
I have a question that might've been answered before, although I
searched and found no answer.. I'm having a problem setting an alias
to a field when performing a query.
For example:
db().select(db.auth_user.first_name.with_alias('name'));
When i execute that it throws:
ProgrammingError: syntax error at or near "AS"
LINE 1: SELECT (auth_user.first_name AS name) FROM auth_user;
the correct query should be built without the "(" ")".. Is there any
way to make such a query?
thanks very much!
beto
