Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'file'.
|
|
The error occurred in D:/home/baseballhistorian.com/wwwroot/html/american_heroes.cfm: line 40
|
38 : FROM AmericanHeroes ,
39 : AmericanHeroesIcons
40 : WHERE AmericanHeroes.Page = #page_number#
41 : AND AmericanHeroes.Active = true
42 : AND AmericanHeroes.Icon = AmericanHeroesIcons.Icons_id
|
|
SQLSTATE |
HY000 |
DATASOURCE |
swingbatter |
VENDORERRORCODE |
156 |
SQL |
SELECT
AmericanHeroes.american_hero_id ,
AmericanHeroes.First_name ,
AmericanHeroes.Last_name ,
AmericanHeroes.Teams ,
AmericanHeroes.americategory,
AmericanHeroes.Page ,
AmericanHeroes.Fact ,
AmericanHeroes.Icon ,
AmericanHeroes.Active ,
AmericanHeroesIcons.Icons_id ,
AmericanHeroesIcons.file
FROM AmericanHeroes ,
AmericanHeroesIcons
WHERE AmericanHeroes.Page = 280
AND AmericanHeroes.Active = true
AND AmericanHeroes.Icon = AmericanHeroesIcons.Icons_id
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
3.93.59.171 |
Referrer |
|
Date/Time |
28-Mar-24 08:24 AM |
|