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 |
162.158.107.60 |
| Referrer |
|
| Date/Time |
25-May-19 07:01 PM |
|
