Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
|
|
The error occurred in C:/inetpub/wwwroot/maps/veg_map_2019.cfm: line 498
Called from C:/inetpub/wwwroot/maps/veg_map_2019.cfm: line 167
Called from C:/inetpub/wwwroot/maps/veg_map_2019.cfm: line 1
Called from C:/inetpub/wwwroot/maps/veg_map_2019.cfm: line 498
Called from C:/inetpub/wwwroot/maps/veg_map_2019.cfm: line 167
Called from C:/inetpub/wwwroot/maps/veg_map_2019.cfm: line 1
|
496 : <CFQUERY NAME="gettracks" DATASOURCE="signals_admin3">
497 : SELECT datafilter FROM animals
498 : WHERE SPECIES_ID = #points.speciesid# and YEAR like '%#DATA_YEAR#%' and datafilter <> 'anytime'
499 : </CFQUERY>
500 :
|
|
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 |
3.215.79.206 |
Referrer |
http://www.signalsofspring.net/student_maps_data_new.cfm?DATA_YEAR=2006&who=scoter&imagery=Vegetation&user= |
Date/Time |
29-Mar-24 11:04 AM |
|