[ https://issues.apache.org/jira/browse/OFBIZ-12671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ingo Wolfmayr closed OFBIZ-12671. --------------------------------- Resolution: Fixed Use single quotes in sql statements. > Entity SQL Processor "where" issue > ---------------------------------- > > Key: OFBIZ-12671 > URL: https://issues.apache.org/jira/browse/OFBIZ-12671 > Project: OFBiz > Issue Type: Improvement > Components: webtools > Affects Versions: Upcoming Branch > Reporter: Ingo Wolfmayr > Priority: Major > > The entity sql processor in webtools fails with: > {code:java} > SELECT * FROM ofbiz.CONTACT_MECH WHERE INFO_STRING = > "ofbizt...@example.com"{code} > results in > {code:java} > SQL Exception while executing the following:SELECT * FROM ofbiz.CONTACT_MECH > WHERE INFO_STRING = "ofbizt...@example.com" (Column 'ofbizt...@example.com' > is either not in any table in the FROM list or appears within a join > specification and is outside the scope of the join specification or appears > in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or > ALTER TABLE statement then 'ofbizt...@example.com' is not a column in the > target table.){code} -- This message was sent by Atlassian Jira (v8.20.10#820010)