You are here

Lucee 5.3.2.77 Error (database)
Message Unexpected token: in statement [SELECT id,father FROM arguments_rsArg WHERE id =]
SQL SELECT id,father FROM arguments_rsArg WHERE id =
DatabaseName HSQL Database Engine
DatabaseVersion 1.8.0
DriverName HSQL Database Engine Driver
DriverVersion 1.8.0
Datasource _queryofquerydb
Stacktrace The Error Occurred in
C:\siti\crevaosweb\_sottomenu.cfm: line 4
2: <cfargument name="cepadre" type="string">
3: <cfargument name="rsArg" type="query">
4: <cfquery dbtype="query" name="contrix">SELECT id,father FROM arguments.rsArg WHERE id = #arguments.cepadre#</cfquery>
5: <cfif contrix.father EQ 0>
6: <cfset idpadre = contrix.id>

called from C:\siti\crevaosweb\_sottomenu.cfm: line 12
called from C:\siti\crevaosweb\page.cfm: line 161
Java Stacktrace lucee.runtime.exp.DatabaseException: Unexpected token: in statement [SELECT id,father FROM arguments_rsArg WHERE id =]
  at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
  at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
  at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:286)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:261)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:215)
  at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:356)
  at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:319)
  at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:307)
  at lucee.runtime.tag.Query.executeQoQ(Query.java:1029)
  at lucee.runtime.tag.Query._doEndTag(Query.java:638)
  at lucee.runtime.tag.Query.doEndTag(Query.java:537)
  at _sottomenu_cfm$cf.udfCall(/_sottomenu.cfm:4)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
  at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:765)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:768)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1707)
  at _sottomenu_cfm$cf.call(/_sottomenu.cfm:12)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:942)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:834)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:816)
  at page_cfm$cf.call(/page.cfm:161)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:942)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:834)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2409)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2399)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2374)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1037)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:983)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  at org.apache.catalina.valves.rewrite.RewriteValve.invoke(RewriteValve.java:317)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:509)
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1104)
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:745)
 
Timestamp 3/28/24 10:50:47 AM CET