Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
|
|
The error occurred in C:/home/server1.footballdiehards.com/wwwroot/footballdiehards.com/wwwroot/boxscores/getpage.cfm: line 31
Called from C:/home/server1.footballdiehards.com/wwwroot/footballdiehards.com/wwwroot/boxscores/2019/week--3/new-york-giants-at-cincinnati-bengals.cfm: line 1
Called from C:/home/server1.footballdiehards.com/wwwroot/footballdiehards.com/wwwroot/boxscores/getpage.cfm: line 31
Called from C:/home/server1.footballdiehards.com/wwwroot/footballdiehards.com/wwwroot/boxscores/2019/week--3/new-york-giants-at-cincinnati-bengals.cfm: line 1
|
29 : FROM schedule#setyear#, allteams
30 : WHERE week = <cfqueryparam CFSQLTYPE= "CF_SQL_INTEGER" Value = "#boxweek#"> and allteams.TeamID = schedule#setyear#.TeamID
31 : and allteams.teamid = #getteams.oppid[1]#
32 : </cfquery>
33 :
|
|
SQLSTATE |
HY000 |
DATASOURCE |
flash03 |
VENDORERRORCODE |
102 |
SQL |
SELECT week, schedule2019.TeamID, OppID, Homeaway, Day, KOTime, locName, TeamName, teamcolor, teamstats, allteams.TeamID as teamid, homeaway
FROM schedule2019, allteams
WHERE week = (param 1) and allteams.TeamID = schedule2019.TeamID
and allteams.teamid = |
|
Resources:
|
Browser |
claudebot |
Remote Address |
44.210.78.150 |
Referrer |
|
Date/Time |
29-Mar-24 01:17 AM |
|