Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '19'.
|
|
The error occurred in D:/wwwroot/noreastsaltwater/gallery/_listinclude_query.cfm: line 105
Called from D:/wwwroot/noreastsaltwater/gallery/view.cfm: line 72
Called from D:/wwwroot/noreastsaltwater/gallery/view.cfm: line 1
Called from D:/wwwroot/noreastsaltwater/gallery/_listinclude_query.cfm: line 105
Called from D:/wwwroot/noreastsaltwater/gallery/view.cfm: line 72
Called from D:/wwwroot/noreastsaltwater/gallery/view.cfm: line 1
|
103 : AND dbo.photo_photos.id < #p#
104 : ORDER BY photo_datetime DESC, dbo.photo_photos.id DESC
105 : <CFELSE>
106 : ORDER BY photo_datetime DESC, dbo.photo_photos.id DESC
107 : </CFIF>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
noreastgallery |
VENDORERRORCODE |
102 |
SQL |
SELECT dbo.photo_photos.ID, catname, cat, photo_username, userid, title, bigimage, views, photo_datetime
FROM dbo.photo_photos, dbo.photo_categories
WHERE dbo.photo_photos.cat = dbo.photo_categories.id
AND userid = 23366
AND photo_forcontest < 2
AND photo_datetime >= 2012-05-07 19:58:00.0
AND dbo.photo_photos.id > 64291
ORDER BY photo_datetime DESC, dbo.photo_photos.id DESC
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
108.162.245.225 |
Referrer |
|
Date/Time |
19-Apr-21 08:11 AM |
|