Error Executing Database Query.
|
Query Of Queries syntax error.
Encountered "<EOF>.
Incorrect ORDER BY column reference []. Only simple column reference, alias name, and integer column id are allowed. Example: You can use alias to refer to a complex expression: SELECT (a+b)/2 as x FROM T ORDER BY x
|
|
The error occurred in D:/Websites/TournamentBowl.com/wwwroot/cfc_folder/Standings_prep24F.cfc: line 564
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom_doc.cfm: line 81
Called from D:/Websites/TournamentBowl.com/wwwroot/cfc_folder/Standings_prep24F.cfc: line 564
Called from D:/Websites/TournamentBowl.com/wwwroot/Open/Standings_Custom_doc.cfm: line 81
|
562 : <cfelseif listfind('3,4',qryEvent.id_event_formats) GT 0>
563 : ORDER BY status_priority desc, total_overall_points desc, total_overall_pins desc
564 : <cfelse>
565 : ORDER BY status_priority desc, total_overall_pins desc
566 : </cfif>
|
|
EXCEPTIONS |
<small><i>not set</i></small> |
SQL |
SELECT *
FROM qryTeams
WHERE total_scratch_plus_carried > 0
ORDER BY status_priority desc, |
|
Resources:
|
Browser |
claudebot |
Remote Address |
3.128.78.41 |
Referrer |
|
Date/Time |
18-Apr-24 09:58 AM |
|