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 <ranjeev...@gmail.com> 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 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.