Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Ambiguous column name 'gy'.
|
|
The error occurred in D:/home/vhsl-reference.com/wwwroot/master_wl_allyears_Region.cfm: line 887
Called from D:/home/vhsl-reference.com/wwwroot/master_wl_allyears_Region.cfm: line 842
Called from D:/home/vhsl-reference.com/wwwroot/master_wl_allyears_Region.cfm: line 1
Called from D:/home/vhsl-reference.com/wwwroot/master_wl_allyears_Region.cfm: line 887
Called from D:/home/vhsl-reference.com/wwwroot/master_wl_allyears_Region.cfm: line 842
Called from D:/home/vhsl-reference.com/wwwroot/master_wl_allyears_Region.cfm: line 1
|
885 : <cfelseif IsDefined("url.sort") AND url.sort EQ 'gdate'>
886 : ORDER by gy DESC,(team1finalrating+team2finalrating) DESC
887 : <cfelse>
888 : ORDER by (team1finalrating+team2finalrating) DESC
889 : </cfif>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
vhsl2_MSSQL |
VENDORERRORCODE |
209 |
SQL |
SELECT gy,team1pts, team2pts,playoff,gy,team1id, team2id,gamedate, (team1finalrating+team2finalrating) AS gamerating,team1finalrating,team2finalrating,team1seasonwins,team2seasonwins FROM raterbygame
WHERE gamedate > {d '1998-12-30'} AND TEAM1ID IN (SELECT ID FROM TEAMNAMES where REGION ='6A' ) AND TEAM2ID IN (SELECT ID FROM TEAMNAMES where Region ='6A' ) AND gy < 2020
ORDER by gy DESC,(team1finalrating+team2finalrating) DESC
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
44.200.74.73 |
Referrer |
|
Date/Time |
28-Mar-24 04:59 PM |
|