Oops, looks like there was an error
<!-- ==start== dump {ts '2019-07-24 01:28:31'} format: html -->
<div id="x7su" class="-lucee-dump"><script language="JavaScript" type="text/javascript">
function dumpOC(name){var tds=document.all?document.getElementsByTagName('tr'):document.getElementsByName(name);var s=null;name=name;for(var i=0;i<tds.length;i++) {if(document.all && tds[i].name!=name)continue;s=tds[i].style;if(s.display=='none') s.display='';else s.display='none';}}
</script>
<style type="text/css">
div#x7su table {font-family:Verdana, Geneva, Arial, Helvetica, sans-serif; font-size:11px; empty-cells:show; color:#000; border-collapse:collapse;}
div#x7su td {border:1px solid #000; vertical-align:top; padding:2px; empty-cells:show;}
div#x7su td span {font-weight:bold;}
div#x7su td.luceeN0 {color:#333399;border-color:#333399;background-color:#ccf;}
div#x7su td.luceeH0 {color:#333399;border-color:#333399;background-color:#99f;}
div#x7su td.luceeN1 {color:#990000;border-color:#990000;background-color:#fc9;}
div#x7su td.luceeH1 {color:#990000;border-color:#990000;background-color:#f60;}
div#x7su td.luceeN2 {color:#336600;border-color:#336600;background-color:#cf3;}
div#x7su td.luceeH2 {color:#336600;border-color:#336600;background-color:#9c3;}
</style>
<table title="C:\inetpub\wwwroot\browse.cfm:135"><tr><td class="luceeH0" onclick="dumpOC('x7sv');" colspan="3" style="cursor:pointer;"><span>Catch</span><br />Entries: 15</td></tr><tr name="x7sv"><td class="luceeH0">additional</td><td class="luceeN0"><table><tr><td class="luceeH0" onclick="dumpOC('x7sw');" colspan="3" style="cursor:pointer;"><span>Struct (ordered)</span></td></tr><tr name="x7sw"><td class="luceeH0">SQL</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">SELECT * FROM products WHERE web  = 1 AND department='FOOT' AND class= 'WMNS⊂class=WEST' LIMIT 0,9</td></tr></table></td></tr><tr name="x7sw"><td class="luceeH0">DatabaseName</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">MySQL</td></tr></table></td></tr><tr name="x7sw"><td class="luceeH0">DatabaseVersion</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">5.6.36-log</td></tr></table></td></tr><tr name="x7sw"><td class="luceeH0">DriverName</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">MySQL Connector/J</td></tr></table></td></tr><tr name="x7sw"><td class="luceeH0">DriverVersion</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">mysql-connector-java-8.0.15 (Revision: 79a4336f140499bd22dd07f02b708e163844e3d5)</td></tr></table></td></tr><tr name="x7sw"><td class="luceeH0">Datasource</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">istar</td></tr></table></td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">DataSource</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">istar</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">Detail</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">ErrorCode</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">0</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">Extended_Info</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1"></td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">ExtendedInfo</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1"></td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">Message</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1"></td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">NativeErrorCode</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">1267</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">queryError</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">SELECT * FROM products WHERE web  = 1 AND department='FOOT' AND class= 'WMNS⊂class=WEST' LIMIT 0,9</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">Sql</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">SELECT * FROM products WHERE web  = 1 AND department='FOOT' AND class= 'WMNS⊂class=WEST' LIMIT 0,9</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">SQLState</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">HY000</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">StackTrace</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">lucee.runtime.exp.DatabaseException: 
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:799)
	at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:293)
	at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:271)
	at lucee.runtime.type.QueryImpl.&lt;init&gt;(QueryImpl.java:224)
	at lucee.runtime.tag.Query.executeDatasoure(Query.java:951)
	at lucee.runtime.tag.Query.doEndTag(Query.java:700)
	at web_inf180.lucee.components.org.lucee.cfml.base_cfc$cf.udfCall1(/WEB-INF/lucee/components/org/lucee/cfml/Base.cfc:110)
	at web_inf180.lucee.components.org.lucee.cfml.base_cfc$cf.udfCall(/WEB-INF/lucee/components/org/lucee/cfml/Base.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)
	at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:803)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1716)
	at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:35)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:693)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1716)
	at datalayer.components.productrepository_cfc$cf.udfCall1(/DataLayer/Components/ProductRepository.cfc:314)
	at datalayer.components.productrepository_cfc$cf.udfCall(/DataLayer/Components/ProductRepository.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:693)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1716)
	at browse_cfm$cf.call(/browse.cfm:60)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:931)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:821)
	at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:225)
	at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
	at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2462)
	at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2452)
	at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2425)
	at lucee.runtime.engine.Request.exe(Request.java:44)
	at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1091)
	at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1039)
	at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
	at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:486)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">TagContext</td><td class="luceeN0"><table><tr><td class="luceeH2" onclick="dumpOC('x7te');" colspan="3" style="cursor:pointer;"><span>Array</span></td></tr><tr name="x7te"><td class="luceeH2">1</td><td class="luceeN2"><table><tr><td class="luceeH0" onclick="dumpOC('x7tf');" colspan="3" style="cursor:pointer;"><span>Struct</span></td></tr><tr name="x7tf"><td class="luceeH0">codePrintHTML</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">108: 							!---&amp;gt;&amp;lt;cfqueryparam attributecollection=&amp;quot;#item#&amp;quot;&amp;gt;&amp;lt;!---&lt;br&gt;
109: 						!---&amp;gt;&amp;lt;/cfif&amp;gt;&amp;lt;/cfloop&amp;gt;&lt;br&gt;
&lt;b&gt;110: 				&amp;lt;/cfquery&amp;gt;&lt;/b&gt;&lt;br&gt;
111: &lt;br&gt;
112: 				&amp;lt;cfif !isNull(local.___q)&amp;gt;&amp;lt;cfset result.setResult(local.___q)&amp;gt;&amp;lt;/cfif&amp;gt;&lt;br&gt;
</td></tr></table></td></tr><tr name="x7tf"><td class="luceeH0">codePrintPlain</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">108: 							!---&gt;&lt;cfqueryparam attributecollection=&quot;#item#&quot;&gt;&lt;!---
109: 						!---&gt;&lt;/cfif&gt;&lt;/cfloop&gt;
110: 				&lt;/cfquery&gt;
111: 
112: 				&lt;cfif !isNull(local.___q)&gt;&lt;cfset result.setResult(local.___q)&gt;&lt;/cfif&gt;
</td></tr></table></td></tr><tr name="x7tf"><td class="luceeH0">column</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">0</td></tr></table></td></tr><tr name="x7tf"><td class="luceeH0">id</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">??</td></tr></table></td></tr><tr name="x7tf"><td class="luceeH0">line</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">110</td></tr></table></td></tr><tr name="x7tf"><td class="luceeH0">Raw_Trace</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">web_inf180.lucee.components.org.lucee.cfml.base_cfc$cf.udfCall1(/WEB-INF/lucee/components/org/lucee/cfml/Base.cfc:110)</td></tr></table></td></tr><tr name="x7tf"><td class="luceeH0">template</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">C:\inetpub\wwwroot\WEB-INF\lucee\components\org\lucee\cfml\Base.cfc</td></tr></table></td></tr><tr name="x7tf"><td class="luceeH0">type</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">cfml</td></tr></table></td></tr></table></td></tr><tr name="x7te"><td class="luceeH2">2</td><td class="luceeN2"><table><tr><td class="luceeH0" onclick="dumpOC('x7to');" colspan="3" style="cursor:pointer;"><span>Struct</span></td></tr><tr name="x7to"><td class="luceeH0">codePrintHTML</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1"></td></tr></table></td></tr><tr name="x7to"><td class="luceeH0">codePrintPlain</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1"></td></tr></table></td></tr><tr name="x7to"><td class="luceeH0">column</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">0</td></tr></table></td></tr><tr name="x7to"><td class="luceeH0">id</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">??</td></tr></table></td></tr><tr name="x7to"><td class="luceeH0">line</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">35</td></tr></table></td></tr><tr name="x7to"><td class="luceeH0">Raw_Trace</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:35)</td></tr></table></td></tr><tr name="x7to"><td class="luceeH0">template</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">/org/lucee/cfml/Query.cfc</td></tr></table></td></tr><tr name="x7to"><td class="luceeH0">type</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">cfml</td></tr></table></td></tr></table></td></tr><tr name="x7te"><td class="luceeH2">3</td><td class="luceeN2"><table><tr><td class="luceeH0" onclick="dumpOC('x7tx');" colspan="3" style="cursor:pointer;"><span>Struct</span></td></tr><tr name="x7tx"><td class="luceeH0">codePrintHTML</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">312:         productsQry.setSQL(&amp;quot;SELECT * FROM products WHERE web  = 1 AND department='&amp;quot; &amp;amp; departmentId &amp;amp;&amp;quot;' AND class= '&amp;quot; &amp;amp; classId &amp;amp; &amp;quot;' LIMIT &amp;quot; &amp;amp; startRow &amp;amp; &amp;quot;,&amp;quot; &amp;amp; endRow &amp;amp; &amp;quot;&amp;quot;);&lt;br&gt;
313:         //myQry.addParam(name=&amp;quot;bookid&amp;quot;,value=&amp;quot;5&amp;quot;,CFSQLTYPE=&amp;quot;CF_SQL_INTEGER&amp;quot;); // add query param&lt;br&gt;
&lt;b&gt;314:         qryRes = productsQry.execute(); // execute  &lt;/b&gt;&lt;br&gt;
315:         &lt;br&gt;
316:          products = arrayNew(1);&lt;br&gt;
</td></tr></table></td></tr><tr name="x7tx"><td class="luceeH0">codePrintPlain</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">312:         productsQry.setSQL(&quot;SELECT * FROM products WHERE web  = 1 AND department='&quot; &amp; departmentId &amp;&quot;' AND class= '&quot; &amp; classId &amp; &quot;' LIMIT &quot; &amp; startRow &amp; &quot;,&quot; &amp; endRow &amp; &quot;&quot;);
313:         //myQry.addParam(name=&quot;bookid&quot;,value=&quot;5&quot;,CFSQLTYPE=&quot;CF_SQL_INTEGER&quot;); // add query param
314:         qryRes = productsQry.execute(); // execute  
315:         
316:          products = arrayNew(1);
</td></tr></table></td></tr><tr name="x7tx"><td class="luceeH0">column</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">0</td></tr></table></td></tr><tr name="x7tx"><td class="luceeH0">id</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">??</td></tr></table></td></tr><tr name="x7tx"><td class="luceeH0">line</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">314</td></tr></table></td></tr><tr name="x7tx"><td class="luceeH0">Raw_Trace</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">datalayer.components.productrepository_cfc$cf.udfCall1(/DataLayer/Components/ProductRepository.cfc:314)</td></tr></table></td></tr><tr name="x7tx"><td class="luceeH0">template</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">C:\inetpub\wwwroot\DataLayer\Components\ProductRepository.cfc</td></tr></table></td></tr><tr name="x7tx"><td class="luceeH0">type</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">cfml</td></tr></table></td></tr></table></td></tr><tr name="x7te"><td class="luceeH2">4</td><td class="luceeN2"><table><tr><td class="luceeH0" onclick="dumpOC('x7u6');" colspan="3" style="cursor:pointer;"><span>Struct</span></td></tr><tr name="x7u6"><td class="luceeH0">codePrintHTML</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">58:     else if(isDefined(&amp;quot;url.dept&amp;quot;) and isDefined(&amp;quot;url.class&amp;quot;))&lt;br&gt;
59:     {&lt;br&gt;
&lt;b&gt;60:         products = productRepo.GetProductsByDeptAndClass(pageNo, url.dept, url.class); &lt;/b&gt;&lt;br&gt;
61: 				totalPages = productRepo.GetTotalPagesByDeptAndClass(url.dept, url.class);     &lt;br&gt;
62:     }&lt;br&gt;
</td></tr></table></td></tr><tr name="x7u6"><td class="luceeH0">codePrintPlain</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">58:     else if(isDefined(&quot;url.dept&quot;) and isDefined(&quot;url.class&quot;))
59:     {
60:         products = productRepo.GetProductsByDeptAndClass(pageNo, url.dept, url.class); 
61: 				totalPages = productRepo.GetTotalPagesByDeptAndClass(url.dept, url.class);     
62:     }
</td></tr></table></td></tr><tr name="x7u6"><td class="luceeH0">column</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">0</td></tr></table></td></tr><tr name="x7u6"><td class="luceeH0">id</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">??</td></tr></table></td></tr><tr name="x7u6"><td class="luceeH0">line</td><td class="luceeN0"><table><tr><td class="luceeH1">number</td><td class="luceeN1">60</td></tr></table></td></tr><tr name="x7u6"><td class="luceeH0">Raw_Trace</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">browse_cfm$cf.call(/browse.cfm:60)</td></tr></table></td></tr><tr name="x7u6"><td class="luceeH0">template</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">C:\inetpub\wwwroot\browse.cfm</td></tr></table></td></tr><tr name="x7u6"><td class="luceeH0">type</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">cfml</td></tr></table></td></tr></table></td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">type</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1">database</td></tr></table></td></tr><tr name="x7sv"><td class="luceeH0">where</td><td class="luceeN0"><table><tr><td class="luceeH1">string</td><td class="luceeN1"></td></tr></table></td></tr></table></div>
<!-- ==stop== dump -->