Description

Hi,

I'd like to use the "BETWEEN" operator in my select statement. (ex : SELECT * FROM product WHERE price BETWEEN x AND y) Currently i don't see how i can do this. So I write my own function, I give it to you the code, but i think there is a better way to do the same thing cause in fact i just want to quote 2 values separatly. It should be better if the where function do something like that.

The BETWEEN operator is part of SQL-92 and AFAIK is well supported by the RDBMSes Zend_Db abstracts. I would favor implementation of ZF-2142 (Allow the where() method of Zend_Db_Select to accept multiple arguments for automatic quoting) instead of the OP's suggestion: