Hi, I am using version 1.99.2 of web2py and am getting an error when trying to run a query with "contains()" in Google App Engine.
The Model: ======== db.define_table('Site_Main', Field('site', 'string', length=13), Field('companyID', 'list:integer'), Field('active', 'integer'), Field('syncToPalm', 'integer'), migrate=settings.migrate) The Query: ======== rows = db(db.Site_Main.companyID.contains(session.company_id)).select(db.Site_Main.id) The Error: ======= Traceback (most recent call last): File "/home/pallav/Desktop/google_appengine/web2py/gluon/ restricted.py", line 194, in restricted exec ccode in environment File "/home/pallav/Desktop/google_appengine/web2py/applications/ samapp/controllers/datasync.py:sites", line 119, in <module> File "/home/pallav/Desktop/google_appengine/web2py/gluon/ globals.py", line 149, in <lambda> self._caller = lambda f: f() File "/home/pallav/Desktop/google_appengine/web2py/applications/ samapp/controllers/datasync.py:sites", line 42, in sites File "/home/pallav/Desktop/google_appengine/web2py/applications/ samapp/models/datasync/site_data.py", line 67, in read rows = db(db.Site_Main.companyID.contains(session.company_id)).select(db.Site_Main.id) File "/home/pallav/Desktop/google_appengine/web2py/gluon/dal.py", line 5697, in select return self.db._adapter.select(self.query,fields,attributes) File "/home/pallav/Desktop/google_appengine/web2py/gluon/dal.py", line 3351, in select (items, tablename, fields) = self.select_raw(query,fields,attributes) File "/home/pallav/Desktop/google_appengine/web2py/gluon/dal.py", line 3308, in select_raw filters = self.expand(query) File "/home/pallav/Desktop/google_appengine/web2py/gluon/dal.py", line 3192, in expand return expression.op(expression.first) TypeError: CONTAINS() takes exactly 3 arguments (2 given) I have tried looking through the book, and the forums, and searched on Google but found no references to this specific error. Is something broken in the DAL related to GAE in the latest web2py? I am downloading Eclipse to see if I can just debug the DAL myself but any help is appreciated. Thanks Pallav