Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'Login'.
|
|
The error occurred in D:/wwwroot/noreastsaltwater/PostedReports/INCLUDE_listquery.cfm: line 49
Called from D:/wwwroot/noreastsaltwater/postedreports/list.cfm: line 147
Called from D:/wwwroot/noreastsaltwater/PostedReports/INCLUDE_listquery.cfm: line 49
Called from D:/wwwroot/noreastsaltwater/postedreports/list.cfm: line 147
|
47 : <CFELSEIF orderby is "location">
48 : Location ASC
49 : <CFELSEIF orderby is "area">
50 : noreastreference.dbo.SubRegions.SubRegion_Name ASC
51 : </CFIF>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
posted |
VENDORERRORCODE |
102 |
SQL |
SELECT *
FROM REPORTS, noreastreference.dbo.SubRegions, noreastreference.dbo.Regions
WHERE (DatePosted > {ts '2021-01-15 00:33:12'}) AND (DatePosted <{ts '2021-01-16 00:33:12'})
AND report_water_ID=1
AND report_active = 1
AND noreastreference.dbo.SubRegions.subregion_ID = reports.report_area_ID
AND noreastreference.dbo.Regions.region_ID = reports.report_region_ID
ORDER BY
Location asc
Login asc, DatePosted DESC
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
108.162.245.119 |
Referrer |
|
Date/Time |
16-Jan-21 12:33 AM |
|