Re: [sqlalchemy] use of between() with Column.op()

2015-04-10 Thread Horcle
The missing '_and' was it. Thanks! The reason why I am loathe to use between() (which I am doing in the interim) is that I have a generalized query structure to which I pass ad hoc elements based on user selection. If I can somehow deal with dynamically constructing the arguments for the betwee

Re: [sqlalchemy] use of between() with Column.op()

2015-04-10 Thread Mike Bayer
On 4/10/15 10:23 PM, Horcle wrote: I really dig use of the column operator for constructing queries, but have been unsuccessful with using this when the argument is "between." I read somewhere that Column.op(var) when var = "in_" does not work, so I would assume that this is true with "betwee

[sqlalchemy] use of between() with Column.op()

2015-04-10 Thread Horcle
I really dig use of the column operator for constructing queries, but have been unsuccessful with using this when the argument is "between." I read somewhere that Column.op(var) when var = "in_" does not work, so I would assume that this is true with "between." Am I doing something wrong, or i