[Opensource] 5.0 DBObject quoting a 'between' clause incorrectly

Kibler, Daniel (HQP) Daniel.Kibler at rhi.com
Tue Nov 5 10:30:11 PST 2002


You wrote:
>I'm doing a custom where clause with a 'between' comparator, and expresso
>ends up generating the following sql:
>SELECT ... FROM ...
>WHERE COLUMNNAME BETWEEN '3 and 6'

The syntax is BETWEEN '3' and '6'

Dan Kibler
Robert Half International
925 598-7860
925 437-3778 Cell
9254373778 at msg.att.com <mailto:9254373778 at msg.att.com>  Wireless Text
Message

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20021105/1e16e619/attachment-0002.htm


More information about the Opensource mailing list