Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
|
|
The error occurred in C:/inetpub/wwwroot/maps/locationm_map_2006new.cfm: line 364
Called from C:/inetpub/wwwroot/maps/locationm_map_2006new.cfm: line 143
Called from C:/inetpub/wwwroot/maps/locationm_map_2006new.cfm: line 1
Called from C:/inetpub/wwwroot/maps/locationm_map_2006new.cfm: line 364
Called from C:/inetpub/wwwroot/maps/locationm_map_2006new.cfm: line 143
Called from C:/inetpub/wwwroot/maps/locationm_map_2006new.cfm: line 1
|
362 : <CFQUERY NAME="gettracks" DATASOURCE="signals_admin3">
363 : SELECT datafilter FROM animals
364 : WHERE SPECIES_ID = #points.speciesid# and YEAR like '%#DATA_YEAR#%' and datafilter <> 'anytime'
365 : </CFQUERY>
366 :
|
|
SQLSTATE |
HY000 |
DATASOURCE |
signals_admin3 |
VENDORERRORCODE |
156 |
SQL |
SELECT datafilter FROM animals
WHERE SPECIES_ID = and YEAR like '%2003%' and datafilter <> 'anytime'
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
34.229.172.86 |
Referrer |
|
Date/Time |
29-Mar-24 09:24 AM |
|