struct
Cause	struct ErrorCode 102 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'BY'. NextException struct ErrorCode 8180 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. SQLState HY000 StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.sql.Executive.executeQuery(Executive.java:1202) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2210) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358) at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 121 RAW_TRACE at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc TYPE CFML 2 struct COLUMN 0 ID CFINVOKE LINE 172 RAW_TRACE at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 3 struct COLUMN 0 ID CF_LABJOBS LINE 157 RAW_TRACE at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 4 struct COLUMN 0 ID CF_LABJOBS LINE 156 RAW_TRACE at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 5 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 6 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 7 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) TEMPLATE D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc TYPE CFML 8 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 206 RAW_TRACE at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventContext.cfc TYPE CFML 9 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 64 RAW_TRACE at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) TEMPLATE D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc TYPE CFML 10 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 60 RAW_TRACE at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc TYPE CFML 11 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 281 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 12 struct COLUMN 0 ID CF_UDFMETHOD LINE 237 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 13 struct COLUMN 0 ID CF_UDFMETHOD LINE 194 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 14 struct COLUMN 0 ID CF_UDFMETHOD LINE 128 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 15 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 80 RAW_TRACE at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) TEMPLATE D:\inetpub\wwwroot\MachII\mach-ii.cfm TYPE CFML 16 struct COLUMN 0 ID CFINCLUDE LINE 11 RAW_TRACE at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm TYPE CFML 17 struct COLUMN 0 ID CFINCLUDE LINE 3 RAW_TRACE at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\index.cfm TYPE CFML Type java.sql.SQLException SQLState HY000 StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'BY'. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.sql.Executive.executeQuery(Executive.java:1202) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2210) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358) at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 121 RAW_TRACE at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc TYPE CFML 2 struct COLUMN 0 ID CFINVOKE LINE 172 RAW_TRACE at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 3 struct COLUMN 0 ID CF_LABJOBS LINE 157 RAW_TRACE at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 4 struct COLUMN 0 ID CF_LABJOBS LINE 156 RAW_TRACE at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 5 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 6 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 7 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) TEMPLATE D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc TYPE CFML 8 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 206 RAW_TRACE at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventContext.cfc TYPE CFML 9 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 64 RAW_TRACE at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) TEMPLATE D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc TYPE CFML 10 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 60 RAW_TRACE at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc TYPE CFML 11 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 281 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 12 struct COLUMN 0 ID CF_UDFMETHOD LINE 237 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 13 struct COLUMN 0 ID CF_UDFMETHOD LINE 194 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 14 struct COLUMN 0 ID CF_UDFMETHOD LINE 128 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 15 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 80 RAW_TRACE at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) TEMPLATE D:\inetpub\wwwroot\MachII\mach-ii.cfm TYPE CFML 16 struct COLUMN 0 ID CFINCLUDE LINE 11 RAW_TRACE at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm TYPE CFML 17 struct COLUMN 0 ID CFINCLUDE LINE 3 RAW_TRACE at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\index.cfm TYPE CFML Type java.sql.SQLException
DataSource	Live_labmarketplace
Detail	[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'BY'.
ErrorCode	HY000
Message	Error Executing Database Query.
NativeErrorCode	102
RootCause	struct ErrorCode 102 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'BY'. NextException struct ErrorCode 8180 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. SQLState HY000 StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.sql.Executive.executeQuery(Executive.java:1202) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2210) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358) at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 121 RAW_TRACE at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc TYPE CFML 2 struct COLUMN 0 ID CFINVOKE LINE 172 RAW_TRACE at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 3 struct COLUMN 0 ID CF_LABJOBS LINE 157 RAW_TRACE at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 4 struct COLUMN 0 ID CF_LABJOBS LINE 156 RAW_TRACE at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 5 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 6 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 7 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) TEMPLATE D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc TYPE CFML 8 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 206 RAW_TRACE at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventContext.cfc TYPE CFML 9 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 64 RAW_TRACE at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) TEMPLATE D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc TYPE CFML 10 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 60 RAW_TRACE at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc TYPE CFML 11 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 281 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 12 struct COLUMN 0 ID CF_UDFMETHOD LINE 237 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 13 struct COLUMN 0 ID CF_UDFMETHOD LINE 194 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 14 struct COLUMN 0 ID CF_UDFMETHOD LINE 128 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 15 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 80 RAW_TRACE at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) TEMPLATE D:\inetpub\wwwroot\MachII\mach-ii.cfm TYPE CFML 16 struct COLUMN 0 ID CFINCLUDE LINE 11 RAW_TRACE at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm TYPE CFML 17 struct COLUMN 0 ID CFINCLUDE LINE 3 RAW_TRACE at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\index.cfm TYPE CFML Type java.sql.SQLException SQLState HY000 StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'BY'. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.sql.Executive.executeQuery(Executive.java:1202) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2210) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358) at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 121 RAW_TRACE at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc TYPE CFML 2 struct COLUMN 0 ID CFINVOKE LINE 172 RAW_TRACE at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 3 struct COLUMN 0 ID CF_LABJOBS LINE 157 RAW_TRACE at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 4 struct COLUMN 0 ID CF_LABJOBS LINE 156 RAW_TRACE at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 5 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 6 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 7 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) TEMPLATE D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc TYPE CFML 8 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 206 RAW_TRACE at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventContext.cfc TYPE CFML 9 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 64 RAW_TRACE at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) TEMPLATE D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc TYPE CFML 10 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 60 RAW_TRACE at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc TYPE CFML 11 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 281 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 12 struct COLUMN 0 ID CF_UDFMETHOD LINE 237 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 13 struct COLUMN 0 ID CF_UDFMETHOD LINE 194 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 14 struct COLUMN 0 ID CF_UDFMETHOD LINE 128 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 15 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 80 RAW_TRACE at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) TEMPLATE D:\inetpub\wwwroot\MachII\mach-ii.cfm TYPE CFML 16 struct COLUMN 0 ID CFINCLUDE LINE 11 RAW_TRACE at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm TYPE CFML 17 struct COLUMN 0 ID CFINCLUDE LINE 3 RAW_TRACE at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\index.cfm TYPE CFML Type java.sql.SQLException
SQLState	HY000
Sql	SELECT AP.LabJobID, AP.JobTitle, AP.JobDetails, AP.DateEntered, AP.Featured, (SELECT c.CompanyName FROM AMP_Companies as c WHERE c.CompanyID = AP.CompanyID) as CompanyName, CompanyID, (SELECT c.CompanyLogo FROM AMP_Companies as c WHERE c.CompanyID = AP.CompanyID) as CompanyLogo, AP.DisplayStatus, JobLocCountry, JobLocState, JobLocCity FROM AMP_LabJobCategoryAssoc APCA LEFT OUTER JOIN AMP_LabJobs AP ON AP.LabJobID = APCA.LabJobID WHERE AP.ActiveStatus = (param 1) AND APCA.CategoryID = (param 2) ORDER BY
StackTrace	coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:583) at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2210) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358) at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2464) at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2260) at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'BY'. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.sql.Executive.executeQuery(Executive.java:1202) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) ... 131 more
TagContext	array 1 struct COLUMN 0 ID CFQUERY LINE 121 RAW_TRACE at cfLabJobs2ecfc1219033325$funcGETFELABJOBS.runFunction(D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc:121) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FunctionPages\LabJobs.cfc TYPE CFML 2 struct COLUMN 0 ID CFINVOKE LINE 172 RAW_TRACE at cfLabJobs2ecfm2034252160._factor2(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:172) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 3 struct COLUMN 0 ID CF_LABJOBS LINE 157 RAW_TRACE at cfLabJobs2ecfm2034252160._factor3(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:157) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 4 struct COLUMN 0 ID CF_LABJOBS LINE 156 RAW_TRACE at cfLabJobs2ecfm2034252160._factor10(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:156) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 5 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160._factor11(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 6 struct COLUMN 0 ID CF_LABJOBS LINE 1 RAW_TRACE at cfLabJobs2ecfm2034252160.runPage(D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm:1) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\DisplayPages\LabJobs\LabJobs.cfm TYPE CFML 7 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfViewContext2ecfc1374030329$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc:75) TEMPLATE D:\inetpub\wwwroot\MachII\framework\ViewContext.cfc TYPE CFML 8 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 206 RAW_TRACE at cfEventContext2ecfc2092223997$funcDISPLAYVIEW.runFunction(D:\inetpub\wwwroot\MachII\framework\EventContext.cfc:206) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventContext.cfc TYPE CFML 9 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 64 RAW_TRACE at cfViewPageCommand2ecfc1050514763$funcEXECUTE.runFunction(D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc:64) TEMPLATE D:\inetpub\wwwroot\MachII\framework\commands\ViewPageCommand.cfc TYPE CFML 10 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 60 RAW_TRACE at cfEventHandler2ecfc589618921$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc:60) TEMPLATE D:\inetpub\wwwroot\MachII\framework\EventHandler.cfc TYPE CFML 11 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 281 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:281) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 12 struct COLUMN 0 ID CF_UDFMETHOD LINE 237 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLENEXTEVENT.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:237) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 13 struct COLUMN 0 ID CF_UDFMETHOD LINE 194 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcPROCESSEVENTS.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:194) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 14 struct COLUMN 0 ID CF_UDFMETHOD LINE 128 RAW_TRACE at cfRequestHandler2ecfc1751854684$funcHANDLEREQUEST.runFunction(D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc:128) TEMPLATE D:\inetpub\wwwroot\MachII\framework\RequestHandler.cfc TYPE CFML 15 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 80 RAW_TRACE at cfmach2dii2ecfm781185752.runPage(D:\inetpub\wwwroot\MachII\mach-ii.cfm:80) TEMPLATE D:\inetpub\wwwroot\MachII\mach-ii.cfm TYPE CFML 16 struct COLUMN 0 ID CFINCLUDE LINE 11 RAW_TRACE at cfFrontEndSettings2ecfm597665218.runPage(D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm:11) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\FrontEndSettings.cfm TYPE CFML 17 struct COLUMN 0 ID CFINCLUDE LINE 3 RAW_TRACE at cfindex2ecfm576191741.runPage(D:\inetpub\wwwroot\LabMarketplace\index.cfm:3) TEMPLATE D:\inetpub\wwwroot\LabMarketplace\index.cfm TYPE CFML
Type	Database
queryError	[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'BY'.
where	(param 1) = [type='IN', class='java.lang.Integer', value='1', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='80', sqltype='cf_sql_integer']