On 11/7/06, DNeumann [EMAIL PROTECTED] wrote:
Hello list,
To build a dynamic where-statement in my script, i looked here for more
info:
http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_building
statement = my_table.select()
if id:
statement.append_whereclause(my_table.c.id==id)
build the OR clause separately:
list = []
list.append(users.c.user_id==id)
list.append(users.c.user_name==name)
statement = user.select(or_(*list))
or
statement.append_whereclause(or_(*list))
alternate method:
critrerion = users.c.user_id==id
criterion =