Error Executing Database Query.
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY video DESC
LIMIT 1' at line 5
|
|
The error occurred in D:/vsites/GolfTripscom/root/html/_templates/stayandplay/golfpackage.cfm: line 38
Called from D:/vsites/GolfTripscom/root/html/_templates/stayandplay/golfpackage.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/golftennessee/stayandplay/golfpackage.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/_templates/stayandplay/golfpackage.cfm: line 38
Called from D:/vsites/GolfTripscom/root/html/_templates/stayandplay/golfpackage.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/golftennessee/stayandplay/golfpackage.cfm: line 1
|
36 : FROM Videos
37 : WHERE TourOperatorsID = #coursedetail.TourOperatorsID#
38 : AND DestinationID = #coursedetail.DestinationsId#
39 : ORDER BY video DESC
40 : LIMIT 1
|
|
SQLSTATE |
42000 |
DATASOURCE |
GolfTrips_661 |
VENDORERRORCODE |
1064 |
SQL |
SELECT video, title, videocode, tags, videodesc, Revised, Complete, TimesViewed, State, courseid, VideoImage
FROM Videos
WHERE TourOperatorsID = 16
AND DestinationID =
ORDER BY video DESC
LIMIT 1
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
100.26.176.182 |
Referrer |
|
Date/Time |
12-Dec-19 03:26 PM |
|