You have added 1 item to your shopping cart


View Less View More

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][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
 
The error occurred in D:/websites/functions/grpqtypricing.cfc: line 51
Called from D:/websites/functions/displays.cfc: line 52
Called from D:/websites/functions/cart.cfc: line 534
Called from D:/websites/Application.cfm: line 738
Called from D:/websites/Application.cfm: line 721
Called from D:/websites/Application.cfm: line 711
Called from D:/websites/Application.cfm: line 711
Called from D:/websites/Application.cfm: line 683
Called from D:/websites/Application.cfm: line 666
Called from D:/websites/Application.cfm: line 662
Called from D:/websites/Application.cfm: line 658
Called from D:/websites/Application.cfm: line 655
Called from D:/websites/Application.cfm: line 651
Called from D:/websites/Application.cfm: line 648
Called from D:/websites/Application.cfm: line 645
Called from D:/websites/Application.cfm: line 641
Called from D:/websites/Application.cfm: line 1
Called from D:/websites/functions/grpqtypricing.cfc: line 51
Called from D:/websites/functions/displays.cfc: line 52
Called from D:/websites/functions/cart.cfc: line 534
Called from D:/websites/Application.cfm: line 738
Called from D:/websites/Application.cfm: line 721
Called from D:/websites/Application.cfm: line 711
Called from D:/websites/Application.cfm: line 711
Called from D:/websites/Application.cfm: line 683
Called from D:/websites/Application.cfm: line 666
Called from D:/websites/Application.cfm: line 662
Called from D:/websites/Application.cfm: line 658
Called from D:/websites/Application.cfm: line 655
Called from D:/websites/Application.cfm: line 651
Called from D:/websites/Application.cfm: line 648
Called from D:/websites/Application.cfm: line 645
Called from D:/websites/Application.cfm: line 641
Called from D:/websites/Application.cfm: line 1
49 : 			<cfquery name="get_quantity_price_levels" datasource="#application.DS#" maxrows="1">
50 : 			select * from tb_quantityprice_levels where quantityprice_id
51 : 			= #get_group_quantity_pricing.quantityprice_id# and quantity<=#combineditemq# order by quantity desc
52 : 			</cfquery>
53 :             

VENDORERRORCODE   156
SQLSTATE   HY000
SQL    select * from tb_quantityprice_levels where quantityprice_id = and quantity<=1 order by quantity desc
DATASOURCE   celerantSQL
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.237.151.188
Referrer  
Date/Time   19-Dec-14 09:50 AM
Stack Trace
at cfgrpqtypricing2ecfc1641200486$funcINIT.runFunction(D:/websites/functions/grpqtypricing.cfc:51) at cfdisplays2ecfc984703155$funcAJAXCART.runFunction(D:/websites/functions/displays.cfc:52) at cfcart2ecfc170405312$funcADDITEMTOCART.runFunction(D:/websites/functions/cart.cfc:534) at cfApplication2ecfm1527249024._factor4(D:/websites/Application.cfm:738) at cfApplication2ecfm1527249024._factor5(D:/websites/Application.cfm:721) at cfApplication2ecfm1527249024._factor51(D:/websites/Application.cfm:711) at cfApplication2ecfm1527249024._factor52(D:/websites/Application.cfm:711) at cfApplication2ecfm1527249024._factor53(D:/websites/Application.cfm:683) at cfApplication2ecfm1527249024._factor54(D:/websites/Application.cfm:666) at cfApplication2ecfm1527249024._factor55(D:/websites/Application.cfm:662) at cfApplication2ecfm1527249024._factor56(D:/websites/Application.cfm:658) at cfApplication2ecfm1527249024._factor57(D:/websites/Application.cfm:655) at cfApplication2ecfm1527249024._factor58(D:/websites/Application.cfm:651) at cfApplication2ecfm1527249024._factor59(D:/websites/Application.cfm:648) at cfApplication2ecfm1527249024._factor60(D:/websites/Application.cfm:645) at cfApplication2ecfm1527249024._factor71(D:/websites/Application.cfm:641) at cfApplication2ecfm1527249024.runPage(D:/websites/Application.cfm:1) at cfgrpqtypricing2ecfc1641200486$funcINIT.runFunction(D:/websites/functions/grpqtypricing.cfc:51) at cfdisplays2ecfc984703155$funcAJAXCART.runFunction(D:/websites/functions/displays.cfc:52) at cfcart2ecfc170405312$funcADDITEMTOCART.runFunction(D:/websites/functions/cart.cfc:534) at cfApplication2ecfm1527249024._factor4(D:/websites/Application.cfm:738) at cfApplication2ecfm1527249024._factor5(D:/websites/Application.cfm:721) at cfApplication2ecfm1527249024._factor51(D:/websites/Application.cfm:711) at cfApplication2ecfm1527249024._factor52(D:/websites/Application.cfm:711) at cfApplication2ecfm1527249024._factor53(D:/websites/Application.cfm:683) at cfApplication2ecfm1527249024._factor54(D:/websites/Application.cfm:666) at cfApplication2ecfm1527249024._factor55(D:/websites/Application.cfm:662) at cfApplication2ecfm1527249024._factor56(D:/websites/Application.cfm:658) at cfApplication2ecfm1527249024._factor57(D:/websites/Application.cfm:655) at cfApplication2ecfm1527249024._factor58(D:/websites/Application.cfm:651) at cfApplication2ecfm1527249024._factor59(D:/websites/Application.cfm:648) at cfApplication2ecfm1527249024._factor60(D:/websites/Application.cfm:645) at cfApplication2ecfm1527249024._factor71(D:/websites/Application.cfm:641) at cfApplication2ecfm1527249024.runPage(D:/websites/Application.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
	at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.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.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1420)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfgrpqtypricing2ecfc1641200486$funcINIT.runFunction(D:\websites\functions\grpqtypricing.cfc:51)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360)
	at cfdisplays2ecfc984703155$funcAJAXCART.runFunction(D:\websites\functions\displays.cfc:52)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360)
	at cfcart2ecfc170405312$funcADDITEMTOCART.runFunction(D:\websites\functions\cart.cfc:534)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:496)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:355)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301)
	at cfApplication2ecfm1527249024._factor4(D:\websites\Application.cfm:738)
	at cfApplication2ecfm1527249024._factor5(D:\websites\Application.cfm:721)
	at cfApplication2ecfm1527249024._factor51(D:\websites\Application.cfm:711)
	at cfApplication2ecfm1527249024._factor52(D:\websites\Application.cfm:711)
	at cfApplication2ecfm1527249024._factor53(D:\websites\Application.cfm:683)
	at cfApplication2ecfm1527249024._factor54(D:\websites\Application.cfm:666)
	at cfApplication2ecfm1527249024._factor55(D:\websites\Application.cfm:662)
	at cfApplication2ecfm1527249024._factor56(D:\websites\Application.cfm:658)
	at cfApplication2ecfm1527249024._factor57(D:\websites\Application.cfm:655)
	at cfApplication2ecfm1527249024._factor58(D:\websites\Application.cfm:651)
	at cfApplication2ecfm1527249024._factor59(D:\websites\Application.cfm:648)
	at cfApplication2ecfm1527249024._factor60(D:\websites\Application.cfm:645)
	at cfApplication2ecfm1527249024._factor71(D:\websites\Application.cfm:641)
	at cfApplication2ecfm1527249024.runPage(D:\websites\Application.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:297)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	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:46)
	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:201)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)