[ https://issues.apache.org/jira/browse/OFBIZ-1045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12547321 ]
Jacques Le Roux commented on OFBIZ-1045: ---------------------------------------- Sorry Luke but we need a new patch now as EntityOperator.java as recently changed : http://fisheye6.cenqua.com/browse/ofbiz/trunk/framework/entity/src/org/ofbiz/entity/condition/EntityOperator.java Thanks > EntityOperator does not correctly construct SQL for BETWEEN clause > ------------------------------------------------------------------ > > Key: OFBIZ-1045 > URL: https://issues.apache.org/jira/browse/OFBIZ-1045 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: ubuntu 7.04, postgres 8.2, working with SVN release > 4955, but EntityOperator.java has not changed since then. > Reporter: Luke Prentice > Assignee: Adam Heath > Attachments: all-app-framework-EntityOperator.java.diff, > all-app-framework-EntityOperator.java.diff, > all-app-framework-EntityOperator.java.diff > > > when using the BETWEEN EntityOperator the SQL produced is incorrectly > formatted: > ... field1 BETWEEN (value1, value2) > it should be > ... field1 BETWEEN value1 AND value2 > this produces an SQL parse exception. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.