The alias translates literally into AS <alias> in SQL, therefore it
cannot be an existing table, a field or a reserved database keyword.

On Oct 29, 2:21 am, Richard <richar...@gmail.com> wrote:
> Hello,
>
> I have a table that links to multiple "media" tables so I use
> with_alias().
>
> I found that the following causes an error:
>  model = db.media.with_alias('model')
> but this works:
>  model = db.media.with_alias('model_z')
>
> I do have a "model" table so they must be conflicting. What
> restrictions does the with_alias() argument have?
>
> Richard
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---

Reply via email to