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/GCBACart/results.cfm: line 36
Called from D:/inetpub/wwwroot/iEditCarts-Access/GCBACart/results.cfm: line 1
Called from D:/inetpub/wwwroot/iEditCarts-Access/GCBACart/results.cfm: line 36
Called from D:/inetpub/wwwroot/iEditCarts-Access/GCBACart/results.cfm: line 1
34 : 
35 : 
36 : <cfquery name="GetProducts" datasource="#ds#">
37 :     SELECT products.product_id, products.productname, products.metatitle, products.metadescription, products.seolink,
38 :     products.options, products.photo, products.productcode, products.wholesale_price, products.dealermember_price,

SQLSTATE   42000
DATASOURCE   GCBA_Cart
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 '%A1A%' 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   3.87.133.69
Referrer  
Date/Time   28-Mar-24 06:52 AM
Stack Trace
at cfresults2ecfm1913843574._factor10(D:/inetpub/wwwroot/iEditCarts-Access/GCBACart/results.cfm:36) at cfresults2ecfm1913843574.runPage(D:/inetpub/wwwroot/iEditCarts-Access/GCBACart/results.cfm:1) at cfresults2ecfm1913843574._factor10(D:/inetpub/wwwroot/iEditCarts-Access/GCBACart/results.cfm:36) at cfresults2ecfm1913843574.runPage(D:/inetpub/wwwroot/iEditCarts-Access/GCBACart/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 cfresults2ecfm1913843574._factor10(D:\inetpub\wwwroot\iEditCarts-Access\GCBACart\results.cfm:36)
	at cfresults2ecfm1913843574.runPage(D:\inetpub\wwwroot\iEditCarts-Access\GCBACart\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)