Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
|
|
The error occurred in C:/inetpub/wwwroot/maps/location_map_2019.cfm: line 427
Called from C:/inetpub/wwwroot/maps/location_map_2019.cfm: line 155
Called from C:/inetpub/wwwroot/maps/location_map_2019.cfm: line 1
Called from C:/inetpub/wwwroot/maps/location_map_2019.cfm: line 427
Called from C:/inetpub/wwwroot/maps/location_map_2019.cfm: line 155
Called from C:/inetpub/wwwroot/maps/location_map_2019.cfm: line 1
|
425 : <CFQUERY NAME="gettracks" DATASOURCE="signals_admin3">
426 : SELECT datafilter FROM animals
427 : WHERE SPECIES_ID = #points.speciesid# and YEAR like '%#DATA_YEAR#%' and datafilter <> 'anytime'
428 : </CFQUERY>
429 :
|
|
SQLSTATE |
HY000 |
DATASOURCE |
signals_admin3 |
VENDORERRORCODE |
156 |
SQL |
SELECT datafilter FROM animals
WHERE SPECIES_ID = and YEAR like '%2021%' and datafilter <> 'anytime'
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
107.23.85.179 |
Referrer |
|
Date/Time |
19-Mar-24 03:03 AM |
|