I want to build a query by concatenating text, conceptual similar as:
FIND Project WHERE Project.projectUitvoerders CONTAINS ',' +LoggedInRegularUser.LoginName + ','
"projectUitvoerders" is a PlainText field containing usernames separated by a comma (',').
But seems the concatenate doesn't work, I get an SQL syntax error (username = 'awareim'):
WebServlet URL got request with params:
Exception thrown com.bas.connectionserver.server.d Internal error. Error reading business object. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+'awareim'+',%') LIMIT 0,20' at line 1
com.bas.connectionserver.server.d: Internal error. Error reading business object. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+'awareim'+',%') LIMIT 0,20' at line 1
at com.bas.connectionserver.server.ConnectionFactory.sendMessage(Unknown Source)
at com.bas.webapp.common.WebAppUtils.sendMessageToExecutionEngine(Unknown Source)
at com.bas.webapp.common.WebAppUtils.sendMessageToExecutionEngine(Unknown Source)
at com.bas.webapp.thin.a.d.i.a(Unknown Source)
at com.bas.webapp.thin.a.d.i.a(Unknown Source)
at com.bas.webapp.thin.a.d.i.a(Unknown Source)
at com.bas.webapp.thin.a.c.a(Unknown Source)
at com.bas.webapp.thin.a.c.a(Unknown Source)
at com.bas.webapp.thin.servlets.WebInterfaceURLServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188-)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108-)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528-)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
Web server returned error: Internal error. Error reading business object. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+'awareim'+',%') LIMIT 0,20' at line 1
[/color]
So, I've two questions:
