Hi all, I defined a table as below:
db.define_table('category', SQLField('parent_id', 'integer'), SQLField('child_id', 'integer'), SQLField('sort_id', 'integer'), SQLField('name'), SQLField('description')) I want to select the records which parent_id=id as: categorys=db(db.dl_category.id==db.dl_category.parent_id).select() It don't work on GAE, dev_appserver console output: SyntaxError:SQLQuery:right site of filter must be a value or entity It work on build-in server, how can I do it on GAE? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---