Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
The error occurred on line 87.
struct
Browser CCBot/2.0 (https://commoncrawl.org/faq/)
DateTime {ts '2024-10-09 19:24:02'}
Diagnostics Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'. <br>The error occurred on line 87.
GeneratedContent <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"><script type="text/javascript">/* <![CDATA[ */_cf_loadingtexthtml="<img alt=' ' src='/cfscripts/ajax/resources/cf/images/loading.gif'/>"; _cf_contextpath=""; _cf_ajaxscriptsrc="/cfscripts/ajax"; _cf_jsonprefix='//'; _cf_websocket_port=8579; _cf_flash_policy_port=1243; _cf_clientid='7E66182CAB6DE57207465393F78E6F2E';/* ]]> */</script><script type="text/javascript" src="/cfscripts/ajax/messages/cfmessage.js"></script> <script type="text/javascript" src="/cfscripts/ajax/package/cfajax.js"></script> <script type="text/javascript" src="/cfscripts/cfform.js"></script> <script type="text/javascript" src="/cfscripts/masks.js"></script> <script type="text/javascript" src="/cfscripts/cfformhistory.js"></script> <script type="text/javascript" src="/cfscripts/ajax/ext/ext-all.js"></script> <script type="text/javascript" src="/cfscripts/ajax/package/cfwindow.js"></script> <link rel="stylesheet" type="text/css" href="/cfscripts/ajax/resources/ext/css/ext-all.css" /> <link rel="stylesheet" type="text/css" href="/cfscripts/ajax/resources/cf/cf.css" /> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="canonical" href="https://www.guardianjet.com/about-guardian-jet/events.cfm?eventid=2023-jetnet-iq-global-business-aviation-summit-1076"> <meta name="description" content=""> <meta property="og:locale" content="en_US"> <meta property="og:type" content="website"> <meta property="og:title" CONTENT="" /> <meta property="og:Description" CONTENT="Guardian Jet News: " /> <meta property="og:url" CONTENT="https://www.guardianjet.com/about-guardian-jet/events.cfm?eventID=-" /> <meta property="og:image" CONTENT="https://www.guardianjet.com" /> <meta property="og:site_name" content="Guardian Jet"> <meta name="twitter:card" content="summary"> <meta name="twitter:description" content=""> <meta name="twitter:title" content="Guardian Jet"> <link rel="stylesheet" href="https://use.typekit.net/xaq0mfn.css"> <script src="https://kit.fontawesome.com/b21a43be08.js"></script> <link rel="stylesheet" href="/css/vendor/bootstrap.min.css"> <link rel="stylesheet" href="/css/vendor/selectize.css"> <link rel="stylesheet" href="/css/style.css?qs=1"> <link rel="stylesheet" href="/css/style_bfs.css?qs=2" type="text/css" media="screen, print" title="default" /> <script src="/js/vendor/jquery-3.4.1.min.js"></script> <script src="/js/vendor/jquery.lazy.min.js"></script> <script src="/js/vendor/selectize.min.js"></script> <script src="/js/vendor/emergence.min.js"></script> <script src="/js/vendor/isotope.pkgd.js"></script> <script src="/js/vendor/bootstrap.min.js"></script> <script src="/js/scripts.js"></script> <script src="/js/javascript.js" type="text/javascript"></script> <script type='text/javascript' src='https://platform-api.sharethis.com/js/sharethis.js#property=5d69864b16b81b0012138a69&product=inline-share-buttons' async='async'></script> <script src='https://www.google.com/recaptcha/api.js?render=6LdlCmUjAAAAAME2ntnudP7Qo2RC_QWEav9BMdAd'></script> <!-- Google Tag Manager --> <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-PL38MLL');</script> <!-- End Google Tag Manager --> <!-- google code --> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-34628051-1']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); </script> <!-- end google code --> <link rel="apple-touch-icon" sizes="180x180" href="/apple-touch-icon.png"> <link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png"> <link rel="icon" type="image/png" sizes="16x16" href="/favicon-16x16.png"> <link rel="mask-icon" href="/safari-pinned-tab.svg" color="#1f3c73"> <script type="text/javascript">/* <![CDATA[ */ ColdFusion.Ajax.importTag('CFAJAXPROXY'); /* ]]> */</script> <script type="text/javascript">/* <![CDATA[ */ ColdFusion.Ajax.importTag('CFFORM'); /* ]]> */</script> <script type="text/javascript">/* <![CDATA[ */ ColdFusion.Ajax.importTag('CFDIV'); /* ]]> */</script> <script type="text/javascript">/* <![CDATA[ */ ColdFusion.Ajax.importTag('CFWINDOW'); /* ]]> */</script> </head> <body> <!-- Google Tag Manager (noscript) --> <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-PL38MLL" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript> <!-- End Google Tag Manager (noscript) --> <nav class="navbar navbar-inverse navbar-fixed-top"> <div class="container"> <div class="header-contact mobile"> <a href="/info/contact.cfm">Contact</a>| <a href="tel:+12034530800">203-453-0800</a>| <a class="vault-login" href="#pop_modalLogin" data-toggle="modal" data-target="#pop_modalLogin" onclick="ColdFusion.navigate('/includes/pop_modalLogin.cfm','div_modalLogin')">Vault Login<i class="fas fa-lock"></i></a> </div> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse"> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a class="navbar-brand" href="/"></a> </div> <div class="header-contact desktop"> <a href="/info/contact.cfm">Contact</a>| <a href="tel:+12034530800">203-453-0800</a>| <a class="vault-login" href="#pop_modalLogin" data-toggle="modal" data-target="#pop_modalLogin" onclick="ColdFusion.navigate('/includes/pop_modalLogin.cfm','div_modalLogin')">Vault Login<i class="fas fa-lock"></i></a> </div> <div class="collapse navbar-collapse"> <ul class="nav navbar-nav pull-right"> <li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown">Listings <i class="fas fa-chevron-down"></i></a> <ul class="dropdown-menu"> <li> <a href="/aircraft-for-sale-listings/private-jets-for-sale.cfm">Private Jets For Sale</a> </li> <li> <a href="/aircraft-for-sale-listings/recent-aircraft-sales.cfm">Recent Aircraft Sales</a> </li> </ul> </li> <li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown">Services <i class="fas fa-chevron-down"></i></a> <ul class="dropdown-menu"> <li> <a href="/aircraft-sales-buy-services/aircraft-fleet-planning">Fleet Planning</a> <ul> <li> <a href="/aircraft-sales-buy-services/aircraft-fleet-planning/airplane-valuation.cfm">- Aircraft Valuation</a> </li> <li> <a href="/aircraft-sales-buy-services/aircraft-fleet-planning/aviation-travel-analysis.cfm">- Travel Analysis</a> </li> <li> <a href="/aircraft-sales-buy-services/aircraft-fleet-planning/aviation-financial-projections.cfm">- Financial Projections</a> </li> <li> <a href="/aircraft-sales-buy-services/aircraft-fleet-planning/aircraft-asset-management.cfm">- Asset Management Program</a> </li> </ul> </li> <li> <a href="/aircraft-sales-buy-services/buy-plane">Acquisitions</a> <ul> <li> <a href="/aircraft-sales-buy-services/buy-plane/aircraft-wanted-to-buy.cfm">- Seeking Aircraft</a> </li> <li> <a href="/aircraft-sales-buy-services/buy-plane/recent-aircraft-acquisitions.cfm">- Recent Acquisitions</a> </li> </ul> </li> <li> <a href="/aircraft-sales-buy-services/private-jet-sales.cfm">Sales</a> </li> <li> <a href="/aircraft-sales-buy-services/aircraft-appraisal.cfm">Appraisals</a> </li> </ul> </li> <li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown">Online Tools <i class="fas fa-chevron-down"></i></a> <ul class="dropdown-menu"> <li> <a href="/jet-aircraft-online-tools/private-jet-finder.cfm">JetFinder Advanced Search</a> </li> <li> <a href="/jet-aircraft-online-tools/vault-aircraft-management-tool.cfm">Vault</a> </li> <li> <a href="/jet-aircraft-online-tools/aircraft-brochures.cfm">Aircraft Brochures</a> </li> <li> <a href="/jet-aircraft-online-tools/compare-jet-aircraft.cfm">Aircraft Comparison</a> </li> <li> <a href="/jet-aircraft-online-tools/jet-aircraft-cabin-comparison.cfm">Cabin Comparison</a> </li> <li> <a href="/jet-aircraft-online-tools/jet-aircraft-range-ring-comparison.cfm">Range Rings</a> </li> <li> <a href="/jet-aircraft-online-tools/aircraft-ownership-budget-projection.cfm">Create a Budget</a> </li> </ul> </li> <li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown">About <i class="fas fa-chevron-down"></i></a> <ul class="dropdown-menu"> <li> <a href="/about-guardian-jet/aircraft-broker.cfm">About Us</a> </li> <li> <a href="/about-guardian-jet/business-aviation-consulting-team.cfm">Team</a> </li> <li> <a href="/about-guardian-jet/careers-at-guardian-jet.cfm">Careers</a> </li> <li> <a href="/about-guardian-jet/press.cfm">Press</a> </li> <li> <a href="/about-guardian-jet/events.cfm">Events</a> </li> </ul> </li> <li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown">Learning Center <i class="fas fa-chevron-down"></i></a> <ul class="dropdown-menu"> <li> <a href="/aircraft-learning-center/jet-aircraft-blog">Blog</a> <ul> </ul> </li> <li> <a href="/aircraft-learning-center/videos.cfm">Videos</a> </li> <li> <a href="/aircraft-learning-center/guardian-university.cfm">Guardian University</a> </li> </ul> </li> </ul> </div><!--/.nav-collapse --> </div> </nav> <section class="top row"> <h2 class="subpage center">Press</h2> <div class="container"> <div class="col-lg-1 col-md-1 col-sm-12 col-xs-12"> </div> <div class="blog-right-side col-lg-4 col-md-4 col-sm-12 col-xs-12"> <div class="row media-contact"> <h3 class="grey">Media Contact</h3> <hr /> <p class="grey">Jill Henning</p> jill@forwardstmarketing.com<br /> <a class="gold" href="tel:+12034530800">+1 203-453-0800</a> </div> <div class="row newsletter"> <h3>Stay Connected</h3> <hr /> <p>Learn the latest about aircraft sales, brokerage trends and more.</p> <p>By submitting your information, you acknowledge that you may be sent marketing material and newsletters.</p> <p>Your information is secure and will never be shared with any third party. <a class="gold" href="/info/privacy-policy.cfm">View our Privacy Policy</a></p> <!-- Begin Mailchimp Signup Form --> <link href="//cdn-images.mailchimp.com/embedcode/classic-10_7.css" rel="stylesheet" type="text/css" /> <style type="text/css">#mc_embed_signup{background:#fff; clear:left; font:14px Helvetica,Arial,sans-serif; } /* Add your own Mailchimp form style overrides in your site stylesheet or in this style block. We recommend moving this block and the preceding CSS link to the HEAD of your HTML file. */ </style> <style type="text/css">#mc-embedded-subscribe {margin-left:initial;} #mc-embedded-subscribe-form input[type=checkbox]{display: inline; width: auto;margin-right: 10px;} #mergeRow-gdpr {margin-top: 20px;} #mergeRow-gdpr fieldset label {font-weight: normal;} #mc-embedded-subscribe-form .mc_fieldset{border:none;min-height: 0px;padding-bottom:0px;} input.subscribe {width: 200px !important;margin: auto !important;} #mc_embed_signup {max-width: 800px;margin: auto;background-color: #ececec;} </style> <div id="mc_embed_signup"> <form action="https://guardianjet.us2.list-manage.com/subscribe/post?u=84d26ca50e77a50397df51b93&amp;id=c50a4c70fa" class="validate" id="mc-embedded-subscribe-form" method="post" name="mc-embedded-subscribe-form" novalidate="" target="_blank"> <div id="mc_embed_signup_scroll"> <div class="indicates-required"><span class="asterisk">*</span> indicates required</div> <div class="mc-field-group"><label for="mce-EMAIL">Email Address <span class="asterisk">*</span> </label> <input class="required email" id="mce-EMAIL" name="EMAIL" type="email" value="" /></div> <div class="mc-field-group"><label for="mce-FNAME">First Name </label> <input id="mce-FNAME" name="FNAME" type="text" value="" /></div> <div class="mergeRow gdpr-mergeRow content__gdprBlock mc-field-group" id="mergeRow-gdpr"> <div class="content__gdpr"> <fieldset class="mc_fieldset gdprRequired mc-field-group" name="interestgroup_field"><!--<label class="checkbox subfield" for="gdpr_47"><input checked="checked" class="av-checkbox " id="gdpr_47" name="gdpr[47]" type="checkbox" value="Y" /><span>Email</span> </label> <label class="checkbox subfield" for="gdpr_51"><input class="av-checkbox " id="gdpr_51" name="gdpr[51]" type="checkbox" value="Y" /><span>Direct Mail</span> </label> <label class="checkbox subfield" for="gdpr_55"><input class="av-checkbox " id="gdpr_55" name="gdpr[55]" type="checkbox" value="Y" /><span>Customized Online Advertising</span> </label>--></fieldset> </div> <div class="clear" id="mce-responses"> <div class="response" id="mce-error-response" style="display:none">&nbsp;</div> <div class="response" id="mce-success-response" style="display:none">&nbsp;</div> </div> <div aria-hidden="true" style="position: absolute; left: -5000px;"><input name="b_84d26ca50e77a50397df51b93_c50a4c70fa" tabindex="-1" type="text" value="" /></div> <div class="clear"><input class="border-button subscribe" id="mc-embedded-subscribe" name="subscribe" type="submit" value="Subscribe" /></div> </div> </div> </form> <!--End mc_embed_signup--></div> </div>
HTTPReferer [empty string]
Mailto [empty string]
Message Error Executing Database Query.
QueryString eventid=2023-jetnet-iq-global-business-aviation-summit-1076
RemoteAddress 3.236.86.184
RootCause
struct
Cause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.go.execute(BaseStatement.java:4425) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1585) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfnewsDetail2ecfm29752717.runPage(E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm:87) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5201) at cfevents2ecfm123023848.runPage(E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm:28) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfnewsDetail2ecfm29752717.runPage(E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm:87)
TEMPLATE E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 28
RAW_TRACE at cfevents2ecfm123023848.runPage(E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm:28)
TEMPLATE E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm
TYPE CFML
Type java.sql.SQLException
DataSource guardianJet
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
Message Error Executing Database Query.
NativeErrorCode 156
RootCause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.go.execute(BaseStatement.java:4425) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1585) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfnewsDetail2ecfm29752717.runPage(E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm:87) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5201) at cfevents2ecfm123023848.runPage(E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm:28) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfnewsDetail2ecfm29752717.runPage(E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm:87)
TEMPLATE E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 28
RAW_TRACE at cfevents2ecfm123023848.runPage(E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm:28)
TEMPLATE E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql select top 5 * from news with(nolock) where 0= 0 and active = 1 and (golivedate <= '10/09/2024' or golivedate is null) and (expirationdate > '10/09/2024' or expirationdate is null) and (newstype = 'press' or newstype = 'news') and newsid <> order by sortorder,maindate desc
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfnewsDetail2ecfm29752717.runPage(E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm:87) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5201) at cfevents2ecfm123023848.runPage(E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm:28) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.go.execute(BaseStatement.java:4425) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1585) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 52 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfnewsDetail2ecfm29752717.runPage(E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm:87)
TEMPLATE E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 28
RAW_TRACE at cfevents2ecfm123023848.runPage(E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm:28)
TEMPLATE E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
where [empty string]
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfnewsDetail2ecfm29752717.runPage(E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm:87) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5201) at cfevents2ecfm123023848.runPage(E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm:28) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'. at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124) at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193) at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153) at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124) at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273) at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895) at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632) at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661) at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470) at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322) at macromedia.jdbc.sqlserverbase.go.execute(BaseStatement.java:4425) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1585) at coldfusion.sql.Executive.executeQuery(Executive.java:1327) at coldfusion.sql.Executive.executeQuery(Executive.java:1257) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) ... 52 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfnewsDetail2ecfm29752717.runPage(E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm:87)
TEMPLATE E:\inetpub\wwwroot\guardian\includes\newsDetail.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 28
RAW_TRACE at cfevents2ecfm123023848.runPage(E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm:28)
TEMPLATE E:\inetpub\wwwroot\Guardian\about-guardian-jet\events.cfm
TYPE CFML
Template /about-guardian-jet/events.cfm
Type coldfusion.runtime.CfErrorWrapper