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/topiclist.cfm: line 104
Called from D:/wwwroot/noreastsaltwater/discussion/topiclist.cfm: line 80
Called from D:/wwwroot/noreastsaltwater/discussion/topiclist.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_Forum_ID= (param 1)
ORDER BY Topic_isSticky DESC, Topic_lastPostDate DESC, Topic_dateStarted DESC
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
108.162.246.44 |
Referrer |
|
Date/Time |
04-Mar-21 01:20 PM |
|