Currently the dal does not rename field and table names and transparently passes them to the db. "order" is a reserved keyword in SQL because used for "ORDER BY", so it cannot be a table or field name.
On Jan 25, 9:44 pm, rama <[email protected]> wrote: > I tried to create a field name called 'order'. This threw an > exception. Changing to another name called 'item_order' solved this. > > I just wanted to share this. Correct me if I am wrong. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.

