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

[Mike Traum]

I figured I'd toss this out here in case it has been fixed in 5.0.1, even
though it doesn't appear to have been.

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'

mysql doesn't like the single quotes around the '3 and 6'. I'm working on a
fix right now, but figured I'd toss this out there - this one is critical
for me for a upgrade which is happening asap...

Should I remove these quotes all together, or is there a rdbms that needs
them?

Thanks,
Mike

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