the DAL allows you to use AS only for the purpose of renaming tables in left joins, not for the purpose or renaming field names. The reason it does not is that it would introduce a lot of complexity but not necessarily provide a useful functionality. The new DAL will have the ability to do he re-naming at the DAL level.
Perhaps I miss something? Why do you need this? On Jan 28, 5:04 am, Khaled ElAdawy <kha...@el.adawi.name> wrote: > I just want to map this simple query to DAL syntax: > "SELECT field_name FROM table_name AS my_name" > > Regards, -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@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.