Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'.
|
|
The error occurred in D:/home/lagolfclubs.com/wwwroot/GolfApp/Comps/Tournament/Tournaments/SeasonStatsObj.cfc: line 29
Called from D:/home/lagolfclubs.com/wwwroot/GolfApp/Comps/Tournament/Tournaments/SeasonStatsObj.cfc: line 11
Called from D:/home/lagolfclubs.com/wwwroot/clubs/includes/MainContent/Players/RoundsPlayedPageContent.cfm: line 25
Called from D:/home/lagolfclubs.com/wwwroot/clubs/includes/main/Center.cfm: line 74
Called from D:/home/lagolfclubs.com/wwwroot/clubs/NewHome.cfm: line 1179
Called from D:/home/lagolfclubs.com/wwwroot/clubs/NewHome.cfm: line 22
Called from D:/home/lagolfclubs.com/wwwroot/clubs/NewHome.cfm: line 1
Called from D:/home/lagolfclubs.com/wwwroot/GolfApp/Comps/Tournament/Tournaments/SeasonStatsObj.cfc: line 29
Called from D:/home/lagolfclubs.com/wwwroot/GolfApp/Comps/Tournament/Tournaments/SeasonStatsObj.cfc: line 11
Called from D:/home/lagolfclubs.com/wwwroot/clubs/includes/MainContent/Players/RoundsPlayedPageContent.cfm: line 25
Called from D:/home/lagolfclubs.com/wwwroot/clubs/includes/main/Center.cfm: line 74
Called from D:/home/lagolfclubs.com/wwwroot/clubs/NewHome.cfm: line 1179
Called from D:/home/lagolfclubs.com/wwwroot/clubs/NewHome.cfm: line 22
Called from D:/home/lagolfclubs.com/wwwroot/clubs/NewHome.cfm: line 1
|
27 : FROM tblTourSeasons
28 : WHERE Club_ID = '#variables.ClubID#'
29 : AND Year(StartDate) < #TourSeasonYear#
30 : ORDER BY Season_ID DESC
31 : </cfquery>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
lagolfclubs |
VENDORERRORCODE |
156 |
SQL |
SELECT Season_ID
FROM tblTourSeasons
WHERE Club_ID = '32'
AND Year(StartDate) <
ORDER BY Season_ID DESC
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
54.157.35.140 |
Referrer |
https://www.lagolfclubs.com/clubs/NewHome.cfm/Section/RoundsPlayed/ClubID/32 |
Date/Time |
29-Mar-24 03:48 AM |
|