Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'.
|
|
The error occurred in C:/home/investaberdeen.co.uk/wwwroot2022/website/priv/inc/innerSide.cfm: line 29
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/priv/views/inner.cfm: line 126
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/pub/index.cfm: line 276
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/pub/index.cfm: line 23
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/pub/index.cfm: line 13
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/pub/index.cfm: line 1
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/priv/inc/innerSide.cfm: line 29
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/priv/views/inner.cfm: line 126
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/pub/index.cfm: line 276
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/pub/index.cfm: line 23
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/pub/index.cfm: line 13
Called from C:/home/investaberdeen.co.uk/wwwroot2022/website/pub/index.cfm: line 1
|
27 : SELECT ID, navTitle, navLink, active, topID
28 : FROM IM_navigation
29 : WHERE topID = #getInnerTopNav.id#
30 : ORDER BY navOrder
31 : </cfquery>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
investAberdeen2019 |
VENDORERRORCODE |
156 |
SQL |
SELECT ID, navTitle, navLink, active, topID
FROM IM_navigation
WHERE topID =
ORDER BY navOrder
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
18.207.157.152 |
Referrer |
|
Date/Time |
18-Aug-22 03:29 PM |
|