Error Executing Database Query.
|
Unknown column 'draft_picks.year_drafted' in 'field list'
|
|
The error occurred in /home/scottlac/public_html/previous_roster.cfm: line 29
|
27 : LEFT JOIN teams ON players.team_id = teams.team_id
28 : WHERE draft_picks.team_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#team_id#">
29 : AND draft_picks.year_drafted = <cfqueryparam cfsqltype="cf_sql_integer" value="#year#">
30 : ORDER BY players.position
31 :
|
|
SQLSTATE |
42S22 |
DATASOURCE |
tfl |
VENDORERRORCODE |
1054 |
SQL |
SELECT
teams.name,
teams.nickname,
teams.file_name,
players.first_name,
players.last_name,
players.position,
draft_picks.year_drafted,
draft_picks.round_selected
FROM players INNER JOIN draft_picks
ON players.player_id = draft_picks.player_id
LEFT JOIN teams ON players.team_id = teams.team_id
WHERE draft_picks.team_id = (param 1)
AND draft_picks.year_drafted = (param 2)
ORDER BY players.position
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
3.238.130.41 |
Referrer |
|
Date/Time |
29-Mar-24 04:46 AM |
|