Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
|
|
The error occurred in C:/inetpub/wwwroot/maps/wx_map_2019.cfm: line 547
Called from C:/inetpub/wwwroot/maps/wx_map_2019.cfm: line 175
Called from C:/inetpub/wwwroot/maps/wx_map_2019.cfm: line 166
Called from C:/inetpub/wwwroot/maps/wx_map_2019.cfm: line 1
Called from C:/inetpub/wwwroot/maps/wx_map_2019.cfm: line 547
Called from C:/inetpub/wwwroot/maps/wx_map_2019.cfm: line 175
Called from C:/inetpub/wwwroot/maps/wx_map_2019.cfm: line 166
Called from C:/inetpub/wwwroot/maps/wx_map_2019.cfm: line 1
|
545 : <CFQUERY NAME="gettracks" DATASOURCE="signals_admin3">
546 : SELECT datafilter FROM animals
547 : WHERE SPECIES_ID = #points.speciesid# and YEAR like '%#DATA_YEAR#%' and datafilter <> 'anytime'
548 : </CFQUERY>
549 :
|
|
SQLSTATE |
HY000 |
DATASOURCE |
signals_admin3 |
VENDORERRORCODE |
156 |
SQL |
SELECT datafilter FROM animals
WHERE SPECIES_ID = and YEAR like '%2006%' and datafilter <> 'anytime'
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
18.233.223.189 |
Referrer |
http://www.signalsofspring.net/student_maps_data_new.cfm?DATA_YEAR=2006&who=scoter&imagery=Weather&user= |
Date/Time |
28-Mar-24 06:31 PM |
|