Hi, I define two tables in my application as:
db.define_table( "block_names" , Field("block_name" ,default=None) ) db.define_table( "block_data" , Field("block_names_id" ,default=None) , Field("product_number" ,default=None) , Field("product_revision" ,default=None) , Field("product_path" ,default=None) , Field("branch" ,default=None) , Field("bat_file_path" ,default=None) , Field("toolbox" ,default=None) ) I am trying to run following query: rows = db((db.block_names.id > 0) &(db.block_names.id == db.block_data.block_names_id)).select(db.block_names.block_name, db.block_data.ALL) And I get this error: File ".../sqr_enumerate_pairs.py", line 77, in EnumeratePairs &(db.block_names.id == db.block_data.block_names_id)).select(db.block_names.block_name, db.block_data.ALL) File "/.../web2py/gluon/dal.py", line 7578, in select return adapter.select(self.query,fields,attributes) File "/.../web2py/gluon/dal.py", line 1315, in select rows = response(sql) File "/.../web2py/gluon/dal.py", line 1305, in response self.execute(sql) File "/.../web2py/gluon/dal.py", line 1392, in execute return self.log_execute(*a, **b) File "/.../web2py/gluon/dal.py", line 1386, in log_execute ret = self.cursor.execute(*a, **b) ProgrammingError: operator does not exist: integer = character varying at character 309 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. I am using latest 1.99.7 Web2py, latest 9.1.2 Postgres, and latest 2.4.4 psycopg2 driver. Any help is welcomed :-) BR Loreia