Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'AND'.
|
|
The error occurred in C:/home/2020projectmanagement.com/wwwroot/Website/pub/includes/getCourses.cfm: line 37
Called from C:/home/2020projectmanagement.com/wwwroot/Website/priv/inc/courses.cfm: line 71
Called from C:/home/2020projectmanagement.com/wwwroot/Website/priv/views/course-cats.cfm: line 60
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 223
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 164
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 67
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 15
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 1
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/includes/getCourses.cfm: line 37
Called from C:/home/2020projectmanagement.com/wwwroot/Website/priv/inc/courses.cfm: line 71
Called from C:/home/2020projectmanagement.com/wwwroot/Website/priv/views/course-cats.cfm: line 60
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 223
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 164
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 67
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 15
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 1
|
35 : IM_navigation.courseTemplate = 1
36 : </cfif>
37 : <cfelse>
38 : IM_navigation.featured = 1
39 : </cfif>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
2020project |
VENDORERRORCODE |
156 |
SQL |
SELECT IM_navigation.ID, IM_navigation.navTitle, IM_navigation.navLink, IM_pageContent.image, IM_pageContent.imageFocus, IM_navigation.topID
FROM IM_navigation INNER JOIN
IM_pageContent ON IM_navigation.ID = IM_pageContent.navID
WHERE
IM_navigation.topID =
AND IM_navigation.active = 1
ORDER BY IM_navigation.navOrder ASC
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
3.236.228.250 |
Referrer |
|
Date/Time |
20-Apr-21 06:32 AM |
|