Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '2019'.
|
|
The error occurred in D:/wwwroot/noreastsaltwater/classifieds/adlistQuery.cfm: line 215
Called from D:/wwwroot/noreastsaltwater/classifieds/viewad.cfm: line 174
Called from D:/wwwroot/noreastsaltwater/classifieds/adlistQuery.cfm: line 215
Called from D:/wwwroot/noreastsaltwater/classifieds/viewad.cfm: line 174
|
213 : AND userID = #client.um_users_ID#
214 : </CFIF>
215 : ORDER BY startdate <CFIF prevNextAd IS "prev">ASC<CFELSE>DESC</CFIF>
216 : </CFQUERY>
217 : <CFIF search IS NOT "advanced" AND getNP.recordcount GT 0>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
NoreastClassifiedAds |
VENDORERRORCODE |
102 |
SQL |
SELECT * FROM dbo.Classifieds
WHERE startdate <= {ts '2019-12-05 15:59:39'}
AND enddate >= {ts '2019-12-05 15:59:39'}
AND isActivated = 1
AND startdate > '{ts '2019-12-05 15:59:39'}'
ORDER BY startdate ASC |
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
108.162.245.195 |
Referrer |
|
Date/Time |
05-Dec-19 03:59 PM |
|