Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'products.Preference%2Cproducts.ProductName'.
 
The error occurred in D:/inetpub/wwwroot/iEditCarts-Access/PinSaver/results.cfm: line 70
Called from D:/inetpub/wwwroot/iEditCarts-Access/PinSaver/results.cfm: line 1
Called from D:/inetpub/wwwroot/iEditCarts-Access/PinSaver/results.cfm: line 70
Called from D:/inetpub/wwwroot/iEditCarts-Access/PinSaver/results.cfm: line 1
68 : 	       ORDER BY IIF(products.apply_sale = 1 AND products.sale_price > 0, products.sale_price, products.price) desc
69 : 	    <cfelse>
70 : 	       ORDER BY #SortBy#
71 : 	    </cfif>
72 : 	 </cfif>

SQLSTATE   42000
DATASOURCE   PinsaverCart
VENDORERRORCODE   -3100
SQL    SELECT products.product_id, products.productname, products.metatitle, products.metadescription, products.seolink, products.options, products.photo, products.productcode, products.wholesale_price, products.dealermember_price, products.apply_sale, products.price, products.retail_price, products.sale_price, products.brandname, products.qtyinstock, products.shipping_free, products.Preference, quantitypricing.group_id, quantitypricing.discounttype, products.dateentered, products.sold, products.rating, MIN(QuantityPricing.Amount) AS MINQtyPrice, MAX(QuantityPricing.Amount) AS MAXQtyPrice, IIF(products.apply_sale = 1 AND products.sale_price > 0, products.sale_price, products.price) AS sortingprice FROM products LEFT OUTER JOIN QuantityPricing ON products.product_ID = QuantityPricing.product_ID WHERE products.Suspend = 0 AND products.price > 0 AND products.Categories LIKE '%A12A%' GROUP BY products.product_id, products.productname, products.metatitle, products.metadescription, products.seolink, products.options, products.photo, products.productcode, products.wholesale_price, products.dealermember_price, products.apply_sale, products.price, products.retail_price, products.sale_price, products.brandname, products.qtyinstock, products.shipping_free, products.Preference, quantitypricing.group_id, quantitypricing.discounttype, products.dateentered, products.sold, products.rating ORDER BY products.Preference%2Cproducts.ProductName
Resources:

Browser   claudebot
Remote Address   44.213.99.37
Referrer  
Date/Time   19-Mar-24 12:07 AM
Stack Trace
at cfresults2ecfm1373918611._factor9(D:/inetpub/wwwroot/iEditCarts-Access/PinSaver/results.cfm:70) at cfresults2ecfm1373918611.runPage(D:/inetpub/wwwroot/iEditCarts-Access/PinSaver/results.cfm:1) at cfresults2ecfm1373918611._factor9(D:/inetpub/wwwroot/iEditCarts-Access/PinSaver/results.cfm:70) at cfresults2ecfm1373918611.runPage(D:/inetpub/wwwroot/iEditCarts-Access/PinSaver/results.cfm:1)

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'products.Preference%2Cproducts.ProductName'.
	at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
	at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decode(Unknown Source)
	at macromedia.sequelink.ssp.Chain.send(Unknown Source)
	at macromedia.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown Source)
	at macromedia.jdbc.sequelink.SequeLinkImplStatement.execute(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1461)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfresults2ecfm1373918611._factor9(D:\inetpub\wwwroot\iEditCarts-Access\PinSaver\results.cfm:70)
	at cfresults2ecfm1373918611.runPage(D:\inetpub\wwwroot\iEditCarts-Access\PinSaver\results.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	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:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.seefusion.Filter.doFilter(Filter.java:109)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)