Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '06'. The error occurred in D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm: line 104

Called from D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm: line 80

Called from D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm: line 1

Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 10

Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 1

Called from D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm: line 104

Called from D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm: line 80

Called from D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm: line 1

Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 10

Called from D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm: line 1

102 : <CFIF um_loginlevel IS NOT "club">AND clubOnly = 0</CFIF> 103 : </CFIF> 104 : ORDER BY <CFIF list IS "inForum">Topic_isSticky DESC,</CFIF> Topic_lastPostDate DESC, Topic_dateStarted DESC 105 : </CFQUERY> 106 : <!--- <CFIF client.um_users_ID IS 9185><cfdump var="#topics#"></CFIF> ---> SQLSTATE HY000 DATASOURCE NoreastCFBoard VENDORERRORCODE 102 SQL SELECT topics.*, Forums.Forum_name, forums.forum_ID, dbo.Forums.customColorScheme FROM Topics, Forums WHERE dbo.Topics.Topic_forum_ID=dbo.Forums.Forum_ID AND forum_siteID = 1 AND dbo.topics.topic_deleted = 0 AND (dbo.Topics.Topic_lastPostDate >= 2016-10-23 06:29:08.0 OR topic_isSticky = 1) AND dbo.topics.Topic_numberOfReplies >= 0 AND forum_inmainList = 1 AND Topic_lastPostDate > {ts '2020-09-29 02:51:31'} AND topic_Forum_ID <> 28 AND topic_forum_ID <> 80 AND Forum_hideByUserID = 0 AND clubOnly = 0 ORDER BY Topic_lastPostDate DESC, Topic_dateStarted DESC Resources: Check the ColdFusion documentation to verify that you are using the correct syntax.

Search the Knowledge Base to find a solution to your problem. Browser newspaper/0.2.8 Remote Address 162.158.107.158 Referrer Date/Time 30-Sep-20 02:51 AM Stack Trace at cftopiclist2ecfm1209937060._factor1(D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm:104) at cftopiclist2ecfm1209937060._factor11(D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm:80) at cftopiclist2ecfm1209937060.runPage(D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm:1) at cfViewTopic2ecfm1569125251._factor40(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:10) at cfViewTopic2ecfm1569125251.runPage(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:1) at cftopiclist2ecfm1209937060._factor1(D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm:104) at cftopiclist2ecfm1209937060._factor11(D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm:80) at cftopiclist2ecfm1209937060.runPage(D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm:1) at cfViewTopic2ecfm1569125251._factor40(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:10) at cfViewTopic2ecfm1569125251.runPage(D:/wwwroot/noreastsaltwater/discussion/ViewTopic.cfm:1)



java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '06'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1561) at coldfusion.sql.Executive.executeQuery(Executive.java:1311) at coldfusion.sql.Executive.executeQuery(Executive.java:1241) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1208) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cftopiclist2ecfm1209937060._factor1(D:\wwwroot

oreastsaltwater\discussion\topiclist.cfm:104) at cftopiclist2ecfm1209937060._factor11(D:\wwwroot

oreastsaltwater\discussion\topiclist.cfm:80) at cftopiclist2ecfm1209937060.runPage(D:\wwwroot

oreastsaltwater\discussion\topiclist.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4082) at cfViewTopic2ecfm1569125251._factor40(D:\wwwroot

oreastsaltwater\discussion\ViewTopic.cfm:10) at cfViewTopic2ecfm1569125251.runPage(D:\wwwroot

oreastsaltwater\discussion\ViewTopic.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:729) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:544) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:426) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:844)