Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
The error occurred on line 116.
struct
Browser CCBot/2.0 (https://commoncrawl.org/faq/)
DateTime {ts '2020-08-12 11:52:08'}
Diagnostics Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. <br>The error occurred on line 116.
GeneratedContent <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns:fb="http://www.facebook.com/2008/fbml" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/terms/" xmlns:foaf="http://xmlns.com/foaf/0.1/" xmlns:og="http://ogp.me/ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:sioc="http://rdfs.org/sioc/ns#" xmlns:sioct="http://rdfs.org/sioc/types#" xmlns:skos="http://www.w3.org/2004/02/skos/core#" xmlns:xsd="http://www.w3.org/2001/XMLSchema#" xmlns:owl="http://www.w3.org/2002/07/owl#" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:schema="http://schema.org/" > <!-- /** * The page can be used in ColdFusion applications to check for SQL injections and XSS attacks * It should be used anywhere after the application scope has been initialized but before any page processing takes place * This code is free to use for personal or commercial use. Feel free to email me any comments or improvements. * * @author Mary Jo Sminkey maryjo@dogpatchsw.com * @version 1, July 25, 2008 * @version 2, July 28, 2008 * @version 3, August 15, 2008 * @version 4, August 20, 2008 * @version 5, July 5, 2009 * @version 6, September 25, 2009 */ --> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-22694188-1']); _gaq.push(['_setDomainName', 'dataversity.net']); _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> <!DOCTYPE html> <html dir="ltr" lang="en-US"> <head><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='65AF1F032422B352373D622AC395B7EC';/* ]]> */</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/yui/yahoo-dom-event/yahoo-dom-event.js"></script> <script type="text/javascript" src="/cfscripts/ajax/yui/animation/animation-min.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 content="text/html; charset=utf-8" http-equiv="content-type"/> <meta content="SemiColonWeb" name="author"/> <title>2020 Enterprise Data World: VIRTUAL</title> <!-- Stylesheets --> <link href="https://fonts.googleapis.com/css?family=IBM+Plex+Sans:400,400i,600,600i,700,700i&display=swap" rel="stylesheet"> <link href="/css/bootstrap.css" rel="stylesheet" type="text/css"/> <link href="/css/style-vars.css" rel="stylesheet" type="text/css"/> <link href="/css/swiper.css" rel="stylesheet" type="text/css"/> <link href="/css/dark.css" rel="stylesheet" type="text/css"/> <link href="/css/font-icons.css" rel="stylesheet" type="text/css"/> <link href="/css/animate.css" rel="stylesheet" type="text/css"/> <link href="/css/magnific-popup.css" rel="stylesheet" type="text/css"/> <link href="/css/responsive.css" rel="stylesheet" type="text/css"/> <link href="/css/edw.css" rel="stylesheet" type="text/css"/> <link href="/css/social.css" rel="stylesheet" type="text/css"/> <link href="/css/fontawesome.css" rel="stylesheet" type="text/css"/> <link rel="stylesheet" href="/css/style_bfs.css" type="text/css" media="screen, print" title="default" /> <link rel="stylesheet" href="/uploads/css/2019_144.css" type="text/css" media="screen, print" title="default" /> <link rel="stylesheet" href="/css/gdpr-skyworld.css" type="text/css" media="screen, print" title="default" /> <script type="text/javascript" src="js/javascript.js"></script> <meta content="width=device-width, initial-scale=1" name="viewport"/> <script> String.prototype.trim = function() { return this.replace(/^\s+|\s+$/g,""); } var Cards = new makeArray(8); Cards[0] = new cardtype("MC", "51,52,53,54,55", "16"); var MC = Cards[0]; Cards[1] = new cardtype("Visa", "4", "13,16"); var Visa = Cards[1]; Cards[2] = new cardtype("Amex", "34,37", "15"); var Amex = Cards[2]; Cards[3] = new cardtype("DinersClubCard", "30,36,38", "14"); var DinersClubCard = Cards[3]; Cards[4] = new cardtype("DiscoverCard", "6011", "16"); var DiscoverCard = Cards[4]; Cards[5] = new cardtype("enRouteCard", "2014,2149", "15"); var enRouteCard = Cards[5]; Cards[6] = new cardtype("JCBCard", "3088,3096,3112,3158,3337,3528", "16"); var JCBCard = Cards[6]; var LuhnCheckSum = Cards[7] = new cardtype(); /*************************************************************************\ Checkcardnumber(form) function called when users click the "check" button. \*************************************************************************/ function Checkcardnumber(form) { var tmpyear; if (form.cardnumber.value.length == 0) { //cardMsg = "Please enter a Card Number."; document.getElementById('cardnumberL').className = "formLabel formError"; //form.cardnumber.focus(); return; } tmpyear = form.expy.options[form.expy.selectedIndex].value; tmpmonth = form.expm.options[form.expm.selectedIndex].value; // The following line doesn't work in IE3, you need to change it // to something like "(new cardtype())...". // if (!cardtype().isExpiryDate(tmpyear, tmpmonth)) { if (!(new cardtype()).isExpiryDate(tmpyear, tmpmonth)) { cardMsg = "Invalid expiration date"; document.getElementById('expmL').className = "formLabel formError"; document.getElementById('expyL').className = "formLabel formError"; return; } card = form.cardtype.options[form.cardtype.selectedIndex].value; var retval = eval(card + ".checkcardnumber(\"" + form.cardnumber.value + "\", " + tmpyear + ", " + tmpmonth + ");"); cardname = ""; if (retval) // comment this out if used on an order form //alert("This card number appears to be valid."); return true; else { // The cardnumber has the valid luhn checksum, but we want to know which // cardtype it belongs to. for (var n = 0; n < Cards.size; n++) { if (Cards[n].checkcardnumber(form.cardnumber.value, tmpyear, tmpmonth)) { cardname = Cards[n].getcardtype(); break; } } if (cardname.length > 0) { cardMsg = "This looks like a " + cardname + " number, not a " + card + " number."; document.getElementById('cardnumberL').className = "formLabel formError"; } else { cardMsg = "This card number is not valid."; document.getElementById('cardnumberL').className = "formLabel formError"; } } } /*************************************************************************\ Object cardtype([String cardtype, String rules, String len, int year, int month]) cardtype : type of card, eg: MasterCard, Visa, etc. rules : rules of the cardnumber, eg: "4", "6011", "34,37". len : valid length of cardnumber, eg: "16,19", "13,16". year : year of expiry date. month : month of expiry date. eg: var VisaCard = new cardtype("Visa", "4", "16"); var AmExCard = new cardtype("AmEx", "34,37", "15"); \*************************************************************************/ function cardtype() { var n; var argv = cardtype.arguments; var argc = cardtype.arguments.length; this.objname = "object cardtype"; var tmpcardtype = (argc > 0) ? argv[0] : "CardObject"; var tmprules = (argc > 1) ? argv[1] : "0,1,2,3,4,5,6,7,8,9"; var tmplen = (argc > 2) ? argv[2] : "13,14,15,16,19"; this.setcardnumber = setcardnumber; // set cardnumber method. this.setcardtype = setcardtype; // setcardtype method. this.setLen = setLen; // setLen method. this.setRules = setRules; // setRules method. this.setExpiryDate = setExpiryDate; // setExpiryDate method. this.setcardtype(tmpcardtype); this.setLen(tmplen); this.setRules(tmprules); if (argc > 4) this.setExpiryDate(argv[3], argv[4]); this.checkcardnumber = checkcardnumber; // checkcardnumber method. this.getExpiryDate = getExpiryDate; // getExpiryDate method. this.getcardtype = getcardtype; // getcardtype method. this.iscardnumber = iscardnumber; // iscardnumber method. this.isExpiryDate = isExpiryDate; // isExpiryDate method. this.luhnCheck = luhnCheck;// luhnCheck method. return this; } /*************************************************************************\ boolean checkcardnumber([String cardnumber, int year, int month]) return true if cardnumber pass the luhncheck and the expiry date is valid, else return false. \*************************************************************************/ function checkcardnumber() { var argv = checkcardnumber.arguments; var argc = checkcardnumber.arguments.length; var cardnumber = (argc > 0) ? argv[0] : this.cardnumber; var year = (argc > 1) ? argv[1] : this.year; var month = (argc > 2) ? argv[2] : this.month; this.setcardnumber(cardnumber); this.setExpiryDate(year, month); if (!this.iscardnumber()) return false; if (!this.isExpiryDate()) return false; return true; } /*************************************************************************\ String getcardtype() return the cardtype. \*************************************************************************/ function getcardtype() { return this.cardtype; } /*************************************************************************\ String getExpiryDate() return the expiry date. \*************************************************************************/ function getExpiryDate() { return this.month + "/" + this.year; } /*************************************************************************\ boolean iscardnumber([String cardnumber]) return true if cardnumber pass the luhncheck and the rules, else return false. \*************************************************************************/ function iscardnumber() { var argv = iscardnumber.arguments; var argc = iscardnumber.arguments.length; var cardnumber = (argc > 0) ? argv[0] : this.cardnumber; if (!this.luhnCheck()) return false; for (var n = 0; n < this.len.size; n++) if (cardnumber.toString().length == this.len[n]) { for (var m = 0; m < this.rules.size; m++) { var headdigit = cardnumber.substring(0, this.rules[m].toString().length); if (headdigit == this.rules[m]) return true; } return false; } return false; } /*************************************************************************\ boolean isExpiryDate([int year, int month]) return true if the date is a valid expiry date, else return false. \*************************************************************************/ function isExpiryDate() { var argv = isExpiryDate.arguments; var argc = isExpiryDate.arguments.length; year = argc > 0 ? argv[0] : this.year; month = argc > 1 ? argv[1] : this.month; if (!isNum(year+"")) return false; if (!isNum(month+"")) return false; today = new Date(); expiry = new Date(year, month); if (today.getTime() > expiry.getTime()) return false; else return true; } /*************************************************************************\ boolean isNum(String argvalue) return true if argvalue contains only numeric characters, else return false. \*************************************************************************/ function isNum(argvalue) { argvalue = argvalue.toString(); if (argvalue.length == 0) return false; for (var n = 0; n < argvalue.length; n++) if (argvalue.substring(n, n+1) < "0" || argvalue.substring(n, n+1) > "9") return false; return true; } /*************************************************************************\ boolean luhnCheck([String cardnumber]) return true if cardnumber pass the luhn check else return false. Reference: http://www.ling.nwu.edu/~sburke/pub/luhn_lib.pl \*************************************************************************/ function luhnCheck() { var argv = luhnCheck.arguments; var argc = luhnCheck.arguments.length; var cardnumber = argc > 0 ? argv[0] : this.cardnumber; if (! isNum(cardnumber)) { return false; } var no_digit = cardnumber.length; var oddoeven = no_digit & 1; var sum = 0; for (var count = 0; count < no_digit; count++) { var digit = parseInt(cardnumber.charAt(count)); if (!((count & 1) ^ oddoeven)) { digit *= 2; if (digit > 9) digit -= 9; } sum += digit; } if (sum % 10 == 0) return true; else return false; } /*************************************************************************\ ArrayObject makeArray(int size) return the array object in the size specified. \*************************************************************************/ function makeArray(size) { this.size = size; return this; } /*************************************************************************\ cardtype setcardnumber(cardnumber) return the cardtype object. \*************************************************************************/ function setcardnumber(cardnumber) { this.cardnumber = cardnumber; return this; } /*************************************************************************\ cardtype setcardtype(cardtype) return the cardtype object. \*************************************************************************/ function setcardtype(cardtype) { this.cardtype = cardtype; return this; } /*************************************************************************\ cardtype setExpiryDate(year, month) return the cardtype object. \*************************************************************************/ function setExpiryDate(year, month) { this.year = year; this.month = month; return this; } /*************************************************************************\ cardtype setLen(len) return the cardtype object. \*************************************************************************/ function setLen(len) { // Create the len array. if (len.length == 0 || len == null) len = "13,14,15,16,19"; var tmplen = len; n = 1; while (tmplen.indexOf(",") != -1) { tmplen = tmplen.substring(tmplen.indexOf(",") + 1, tmplen.length); n++; } this.len = new makeArray(n); n = 0; while (len.indexOf(",") != -1) { var tmpstr = len.substring(0, len.indexOf(",")); this.len[n] = tmpstr; len = len.substring(len.indexOf(",") + 1, len.length); n++; } this.len[n] = len; return this; } /*************************************************************************\ cardtype setRules() return the cardtype object. \*************************************************************************/ function setRules(rules) { // Create the rules array. if (rules.length == 0 || rules == null) rules = "0,1,2,3,4,5,6,7,8,9"; var tmprules = rules; n = 1; while (tmprules.indexOf(",") != -1) { tmprules = tmprules.substring(tmprules.indexOf(",") + 1, tmprules.length); n++; } this.rules = new makeArray(n); n = 0; while (rules.indexOf(",") != -1) { var tmpstr = rules.substring(0, rules.indexOf(",")); this.rules[n] = tmpstr; rules = rules.substring(rules.indexOf(",") + 1, rules.length); n++; } this.rules[n] = rules; return this; } </script> <!-- header code --> <!-- Global site tag (gtag.js) - Google Ads: 973824156 --> <script async src="https://www.googletagmanager.com/gtag/js?id=AW-973824156"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'AW-973824156'); </script> <style type="text/css"> #social-list { list-style: none; } #social-list li { list-style-type: none; } </style> <script> !function(f,e,a,t,h,r){if(!f[h]){r=f[h]=function(){r.invoke? r.invoke.apply(r,arguments):r.queue.push(arguments)}, r.queue=[],r.loaded=1*new Date,r.version="1.0.0", f.FeathrBoomerang=r;var g=e.createElement(a), h=e.getElementsByTagName("head")[0]||e.getElementsByTagName("script")[0].parentNode; g.async=!0,g.src=t,h.appendChild(g)} }(window,document,"script","https://cdn.feathr.co/js/boomerang.min.js","feathr"); feathr("fly", "5d2f2cc55666df315532798c"); feathr("sprinkle", "page_view"); </script> <!-- /header code --> <!-- share code --> <!-- /share code--> <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 class="stretched"> <div class="clearfix" id="wrapper"> <!-- Header --> <header class="full-header" id="header"> <div id="header-wrap"> <div class="container clearfix"> <div id="primary-menu-trigger"> <i class="icon-reorder"></i> </div> <!-- from existing --> <!-- /from existing --> <!-- Logo ============================================= --> <div id="logo"> <a class="standard-logo logo__edw" href="/index.cfm"><img alt="Canvas Logo" src="/uploads/ConfSiteAssets/144/images/EDWVirtual-logo3-450x121.jpg"></a> <a class="retina-logo logo__edw" href="/index.cfm"><img alt="Canvas Logo" src="/uploads/ConfSiteAssets/144/images/EDWVirtual-logo3-450x121.jpg"></a> </div> <!-- #logo end --> <!-- Primary Navigation ============================================= --> <nav id="primary-menu"> <ul> <li class="mega-menu"><a href="https://edw2020virtual.dataversity.net/program.cfm?scheduleDay=PRINT"><div>Program</div></a> <div class="mega-menu-content clearfix"> <ul class="mega-menu-column col-5"> <li><a href="https://edw2020virtual.dataversity.net/program.cfm?scheduleDay=PRINT" ><div><i class="fa fa-angle-right"></i>Program</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=369&pgid=4" ><div><i class="fa fa-angle-right"></i>AI and Machine Learning</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=306&pgid=4" ><div><i class="fa fa-angle-right"></i>Agile Data</div></a></li> </ul> <ul class="mega-menu-column col-5"> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=442&pgid=4" ><div><i class="fa fa-angle-right"></i>Blockchain</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=331&pgid=4" ><div><i class="fa fa-angle-right"></i>Business Analytics</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=171&pgid=4" ><div><i class="fa fa-angle-right"></i>Data Architecture</div></a></li> </ul> <ul class="mega-menu-column col-5"> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=160&pgid=4" ><div><i class="fa fa-angle-right"></i>Data Governance</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=432&pgid=4" ><div><i class="fa fa-angle-right"></i>Data Leadership</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=430&pgid=4" ><div><i class="fa fa-angle-right"></i>Data Modeling</div></a></li> </ul> <ul class="mega-menu-column col-5"> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=35&pgid=4" ><div><i class="fa fa-angle-right"></i>Data Strategy</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=460&pgid=4" ><div><i class="fa fa-angle-right"></i>Digital Transformation</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=276&pgid=4" ><div><i class="fa fa-angle-right"></i>Industry Trends</div></a></li> </ul> <ul class="mega-menu-column col-5"> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=28&pgid=4" ><div><i class="fa fa-angle-right"></i>Master Data Management</div></a></li> <li><a href="https://edw2020virtual.dataversity.net/programDetails.cfm?ptype=K&optionID=32&pgid=4" ><div><i class="fa fa-angle-right"></i>New Data Management Technologies</div></a></li> </ul> </div> </li> <li><a href="https://edw2020virtual.dataversity.net/attendees.cfm"><div>Attendees</div></a> <ul> <li><a href="https://edw2020virtual.dataversity.net/attendees.cfm" ><i class="fa fa-angle-right"></i>Attendees</a></li> <li><a href="https://edw2020virtual.dataversity.net/code_of_conduct.cfm?pgid=64" ><i class="fa fa-angle-right"></i>Code of Conduct</a> </li> <li><a href="https://edw2020virtual.dataversity.net/FAQ"><i class="fa fa-angle-right"></i>Frequently Asked Questions</a></li> </ul> </li> <li><a href="https://edw2020virtual.dataversity.net/sponsors.cfm"><div>Sponsors</div></a> </li> <li><a href="https://edw2020virtual.dataversity.net/speakers.cfm"><div>Speakers</div></a> </li> <li class="has-button"><a class="has-button" href="https://content.dataversity.net/2020EDWVirtualRegistrationPage.html"><div class="button button-rounded">Registration</div></a> </li> </ul> </nav> <!-- #primary-menu end --> </div> </div></header><!-- #header end --> </section> <section id="content"> <div class="content-wrap pb-0"> <script> <!-- function openpopup(popurl) { winpops = window.open(popurl,"","width=520, height=550, scrollbars=yes, menubar=no, resizable=0") } --> </script>
HTTPReferer [empty string]
Mailto [empty string]
Message Error Executing Database Query.
QueryString ptype=K&optionID=442&pgid=4
RemoteAddress 54.160.19.155
RootCause
struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddm.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfinclude_programdetails2ecfm783306669._factor4(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:116) at cfinclude_programdetails2ecfm783306669.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707) at cfinclude_template2ecfm804987438.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm:49) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707) at cfprogramDetails2ecfm1035445085.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.seefusion.Filter.doFilter(Filter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:685) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 116
RAW_TRACE at cfinclude_programdetails2ecfm783306669._factor4(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:116)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_INCLUDE_PROGRAMDETAILS
LINE 1
RAW_TRACE at cfinclude_programdetails2ecfm783306669.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:1)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 49
RAW_TRACE at cfinclude_template2ecfm804987438.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm:49)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 3
RAW_TRACE at cfprogramDetails2ecfm1035445085.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm:3)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm
TYPE CFML
Type java.sql.SQLException
DataSource dataversity
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
Message Error Executing Database Query.
NativeErrorCode 102
RootCause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddm.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfinclude_programdetails2ecfm783306669._factor4(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:116) at cfinclude_programdetails2ecfm783306669.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707) at cfinclude_template2ecfm804987438.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm:49) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707) at cfprogramDetails2ecfm1035445085.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.seefusion.Filter.doFilter(Filter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:685) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 116
RAW_TRACE at cfinclude_programdetails2ecfm783306669._factor4(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:116)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_INCLUDE_PROGRAMDETAILS
LINE 1
RAW_TRACE at cfinclude_programdetails2ecfm783306669.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:1)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 49
RAW_TRACE at cfinclude_template2ecfm804987438.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm:49)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 3
RAW_TRACE at cfprogramDetails2ecfm1035445085.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm:3)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql select s.proposalid, attribtitle from schedule s inner join Proposal_Choices pc on s.proposalid = pc.proposalid LEFT JOIN CF_Options co ON co.attribId = pc.attribId AND co.attribType = pc.attribType where pc.proposalId = s.proposalId and pc.attribtype = 'L' and s.proposalid in () order by proposalid,attribtitle
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfinclude_programdetails2ecfm783306669._factor4(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:116) at cfinclude_programdetails2ecfm783306669.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707) at cfinclude_template2ecfm804987438.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm:49) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707) at cfprogramDetails2ecfm1035445085.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.seefusion.Filter.doFilter(Filter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:685) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddm.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 62 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 116
RAW_TRACE at cfinclude_programdetails2ecfm783306669._factor4(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:116)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_INCLUDE_PROGRAMDETAILS
LINE 1
RAW_TRACE at cfinclude_programdetails2ecfm783306669.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:1)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 49
RAW_TRACE at cfinclude_template2ecfm804987438.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm:49)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 3
RAW_TRACE at cfprogramDetails2ecfm1035445085.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm:3)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
where [empty string]
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfinclude_programdetails2ecfm783306669._factor4(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:116) at cfinclude_programdetails2ecfm783306669.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707) at cfinclude_template2ecfm804987438.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm:49) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707) at cfprogramDetails2ecfm1035445085.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm:3) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.seefusion.Filter.doFilter(Filter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:685) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddm.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 62 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 116
RAW_TRACE at cfinclude_programdetails2ecfm783306669._factor4(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:116)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_INCLUDE_PROGRAMDETAILS
LINE 1
RAW_TRACE at cfinclude_programdetails2ecfm783306669.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm:1)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_programdetails.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 49
RAW_TRACE at cfinclude_template2ecfm804987438.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm:49)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\include_template.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 3
RAW_TRACE at cfprogramDetails2ecfm1035445085.runPage(E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm:3)
TEMPLATE E:\inetpub\wwwroot\dataversity\wwwroot\sites2019\programDetails.cfm
TYPE CFML
Template /programDetails.cfm
Type coldfusion.runtime.CfErrorWrapper