[sqlalchemy] column_property and Firebird

2012-01-16 Thread werner
I would like to do this type of thing: namesandvar = column_property(names + + variety) and use it e.g. like: query(db.Cellarbook).filter(db.Drinkinfo.namesandvar.contains(u'menu')) But Firebird SQL doesn't like the + operator, it throws an error Strings cannot be added or subtracted in

Re: [sqlalchemy] column_property and Firebird

2012-01-16 Thread Michael Bayer
On Jan 16, 2012, at 11:46 AM, werner wrote: I would like to do this type of thing: namesandvar = column_property(names + + variety) and use it e.g. like: query(db.Cellarbook).filter(db.Drinkinfo.namesandvar.contains(u'menu')) But Firebird SQL doesn't like the + operator, it

Re: [sqlalchemy] column_property and Firebird

2012-01-16 Thread werner
Michael, On 01/16/2012 05:53 PM, Michael Bayer wrote: On Jan 16, 2012, at 11:46 AM, werner wrote: I would like to do this type of thing: namesandvar = column_property(names + + variety) and use it e.g. like: query(db.Cellarbook).filter(db.Drinkinfo.namesandvar.contains(u'menu')) But