see ticket below:
File "N:/web2py/applications/my_app/models/my_model.py", line 642,
in update_audio_herds
form=SQLFORM.factory(db.my_table,record=db.my_table[b.my_table.id])
File "N:\web2py\gluon\sqlhtml.py", line 1226, in factory
return SQLFORM(DAL(None).define_table(table_name, *fields),
**attributes)
File "N:\web2py\gluon\sqlhtml.py", line 819, in __init__
inp = self.widgets.multiple.widget(field, default)
File "N:\web2py\gluon\sqlhtml.py", line 272, in widget
return OptionsWidget.widget(field, value, **attributes)
File "N:\web2py\gluon\sqlhtml.py", line 206, in widget
options = requires[0].options()
File "N:\web2py\gluon\validators.py", line 438, in options
self.build_set()
File "N:\web2py\gluon\validators.py", line 426, in build_set
records = self.dbset.select(*fields, **dd)
File "N:\web2py\gluon\dal.py", line 5394, in select
return self.db._adapter.select(self.query,fields,attributes)
File "N:\web2py\gluon\dal.py", line 1176, in select
rows = response(sql)
File "N:\web2py\gluon\dal.py", line 1166, in response
self.execute(sql)
File "N:\web2py\gluon\dal.py", line 1251, in execute
return self.log_execute(*a, **b)
File "N:\web2py\gluon\dal.py", line 1246, in log_execute
ret = self.cursor.execute(*a,**b)
ProgrammingError: syntax error at or near ")"
LINE 1: ... my_list.name, my_list.id FROM my_list WHERE (my_list.id
IN ()) ORDER B...
I'm trying to build a multi-list. This used to work with sqlite but
now it's not under postgres. Looks like a null condition isn't being
handled properly with postgres.
web2py Version 1.97.1 Source (2011-06-26 19:25:44)
