Railo 4.2.1.008 Error (database)
Message
Detail Incorrect syntax near '='.
SQL
select Content.Title
from cms, Content
where cms.PhysicalName = 'events'
and cms.ID = content.CMS_ID
and content.Title IS NOT NULL
and content.Title != ''
and content.MappingType_ID =
DatabaseName Microsoft SQL Server
DatabaseVersion 15.00.2000
DriverName Microsoft JDBC Driver 4.0 for SQL Server
DriverVersion 4.0.2206.100
Datasource IBEW309
Stacktrace The Error Occurred in
C:\inetpub\Hosted\W11MCEdev_V3\content.cfc: line 181
179: and content.Title != ''
180: and content.MappingType_ID = #L_MappingType_Title#
181: </cfquery>
182: <cfif isdefined('checkTitle.Title') and trim(checkTitle.Title) neq ''>
183: <cfset pageContent = replacenocase(pageContent,'$$$Title#L_MappingType_Title#$$$',checkTitle.Title,'all')>

called from C:\inetpub\Hosted\W11MCEdev_V3\WebconMCEdev_V3.cfm: line 245
called from C:\inetpub\Hosted\IBEW309\index.cfm: line 113
called from C:\inetpub\Hosted\IBEW309\redirection.cfm: line 113
Java Stacktrace
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216):216
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515):1515
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792):792
  at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689):689
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696):5696
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715):1715
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180):180
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155):155
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662):662
  at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:19):19
  at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:25):25
  at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:214):214
  at railo.runtime.type.QueryImpl.(QueryImpl.java:224):224
  at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687
  at railo.runtime.tag.Query.doEndTag(Query.java:531):531
  at content_cfc$cf.udfCall(C:\inetpub\Hosted\W11MCEdev_V3\content.cfc:181):181
  at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
  at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
  at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:195):195
  at railo.runtime.ComponentImpl._call(ComponentImpl.java:624):624
  at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
  at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1751):1751
  at railo.runtime.tag.Invoke.doComponent(Invoke.java:203):203
  at railo.runtime.tag.Invoke.doEndTag(Invoke.java:176):176
  at webconmcedev_v3_cfm$cf.call(C:\inetpub\Hosted\W11MCEdev_V3\WebconMCEdev_V3.cfm:245):245
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.tag.CFTag.doInclude(CFTag.java:305):305
  at railo.runtime.tag.CFTag.cfmlStartTag(CFTag.java:227):227
  at railo.runtime.tag.CFTag.doStartTag(CFTag.java:159):159
  at index_cfm$cf.call(C:\inetpub\Hosted\IBEW309\index.cfm:113):113
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:39):39
  at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179
  at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331
  at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51):51
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243):243
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
  at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749):749
  at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487):487
  at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412):412
  at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339):339
  at railo.commons.net.HTTPUtil.forward(HTTPUtil.java:551):551
  at railo.runtime.PageContextImpl.forward(PageContextImpl.java:2283):2283
  at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source):-1
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):43
  at java.lang.reflect.Method.invoke(Method.java:606):606
  at railo.runtime.reflection.pairs.MethodInstance.invoke(MethodInstance.java:37):37
  at railo.runtime.reflection.Reflector.callMethod(Reflector.java:839):839
  at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738
  at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1547):1547
  at redirection_cfm$cf.call(C:\inetpub\Hosted\IBEW309\redirection.cfm:113):113
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:39):39
  at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179
  at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331
  at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51):51
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243):243
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222):222
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123):123
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100):100
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408):408
  at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603):603
  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310):310
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145):1145
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615
  at java.lang.Thread.run(Thread.java:744):744
 
Timestamp 11/26/22 3:09:06 AM EST