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 -~----------~----~----~----~------~----~------~--~---