======================
ERROR OCCURED: 23-Oct-14, 09:05 PM
ERROR PAGE: /index.cfm?objectid=4D01140F-DF34-D954-0C4AB82788D45F9A
======================

struct
Detail <br><b>Query Of Queries syntax error.</b><br> Encountered "nLeft > AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
ErrorCode n/a
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message <br><b>Query Of Queries syntax error.</b><br> Encountered "nLeft > AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
StackTrace java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "nLeft > AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:566) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:536) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:131) at coldfusion.sql.Executive.executeQuery(Executive.java:753) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:240) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500) at cf_siteMap2ecfm827879268$funcNAV.runFunction(D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm:42) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cf_siteMap2ecfm827879268.runPage(D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm:65) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfdisplaypageStandard2ecfm975396154.runPage(D:\websites\1\farcry\smellycheese\webskin\dmInclude\displaypageStandard.cfm:35) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cftypes2ecfc647863163$funcGETDISPLAY.runFunction(D:\websites\1\farcry\farcry_core\packages\types\types.cfc:52) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cfdisplay2ecfm1867808473._factor5(D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm:255) at cfdisplay2ecfm1867808473.runPage(D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925) at cfindex2ecfm1728433027.runPage(D:\websites\1\farcry\smellycheese\www\index.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 42
RAW_TRACE at cf_siteMap2ecfm827879268$funcNAV.runFunction(D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm:42)
TEMPLATE D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 65
RAW_TRACE at cf_siteMap2ecfm827879268.runPage(D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm:65)
TEMPLATE D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 35
RAW_TRACE at cfdisplaypageStandard2ecfm975396154.runPage(D:\websites\1\farcry\smellycheese\webskin\dmInclude\displaypageStandard.cfm:35)
TEMPLATE D:\websites\1\farcry\smellycheese\webskin\dmInclude\displaypageStandard.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 52
RAW_TRACE at cftypes2ecfc647863163$funcGETDISPLAY.runFunction(D:\websites\1\farcry\farcry_core\packages\types\types.cfc:52)
TEMPLATE D:\websites\1\farcry\farcry_core\packages\types\types.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 255
RAW_TRACE at cfdisplay2ecfm1867808473._factor5(D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm:255)
TEMPLATE D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_DISPLAY
LINE 1
RAW_TRACE at cfdisplay2ecfm1867808473.runPage(D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm:1)
TEMPLATE D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 14
RAW_TRACE at cfindex2ecfm1728433027.runPage(D:\websites\1\farcry\smellycheese\www\index.cfm:14)
TEMPLATE D:\websites\1\farcry\smellycheese\www\index.cfm
TYPE CFML
Type java.sql.SQLException
SQLState n/a
Sql select * FROM qNav WHERE nLeft > AND nRight < AND nLevel = 3
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cf_siteMap2ecfm827879268$funcNAV.runFunction(D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm:42) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cf_siteMap2ecfm827879268.runPage(D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm:65) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfdisplaypageStandard2ecfm975396154.runPage(D:\websites\1\farcry\smellycheese\webskin\dmInclude\displaypageStandard.cfm:35) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cftypes2ecfc647863163$funcGETDISPLAY.runFunction(D:\websites\1\farcry\farcry_core\packages\types\types.cfc:52) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at cfdisplay2ecfm1867808473._factor5(D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm:255) at cfdisplay2ecfm1867808473.runPage(D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925) at cfindex2ecfm1728433027.runPage(D:\websites\1\farcry\smellycheese\www\index.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 42
RAW_TRACE at cf_siteMap2ecfm827879268$funcNAV.runFunction(D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm:42)
TEMPLATE D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 65
RAW_TRACE at cf_siteMap2ecfm827879268.runPage(D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm:65)
TEMPLATE D:\websites\1\farcry\smellycheese\includedObj\_siteMap.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 35
RAW_TRACE at cfdisplaypageStandard2ecfm975396154.runPage(D:\websites\1\farcry\smellycheese\webskin\dmInclude\displaypageStandard.cfm:35)
TEMPLATE D:\websites\1\farcry\smellycheese\webskin\dmInclude\displaypageStandard.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 52
RAW_TRACE at cftypes2ecfc647863163$funcGETDISPLAY.runFunction(D:\websites\1\farcry\farcry_core\packages\types\types.cfc:52)
TEMPLATE D:\websites\1\farcry\farcry_core\packages\types\types.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 255
RAW_TRACE at cfdisplay2ecfm1867808473._factor5(D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm:255)
TEMPLATE D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_DISPLAY
LINE 1
RAW_TRACE at cfdisplay2ecfm1867808473.runPage(D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm:1)
TEMPLATE D:\websites\1\farcry\farcry_core\tags\navajo\display.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 14
RAW_TRACE at cfindex2ecfm1728433027.runPage(D:\websites\1\farcry\smellycheese\www\index.cfm:14)
TEMPLATE D:\websites\1\farcry\smellycheese\www\index.cfm
TYPE CFML
Type Database
queryError <br><b>Query Of Queries syntax error.</b><br> Encountered "nLeft > AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
where [empty string]