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 739
Called from D:/websites/Application.cfm: line 722
Called from D:/websites/Application.cfm: line 712
Called from D:/websites/Application.cfm: line 712
Called from D:/websites/Application.cfm: line 684
Called from D:/websites/Application.cfm: line 667
Called from D:/websites/Application.cfm: line 663
Called from D:/websites/Application.cfm: line 659
Called from D:/websites/Application.cfm: line 656
Called from D:/websites/Application.cfm: line 652
Called from D:/websites/Application.cfm: line 649
Called from D:/websites/Application.cfm: line 646
Called from D:/websites/Application.cfm: line 642
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 739
Called from D:/websites/Application.cfm: line 722
Called from D:/websites/Application.cfm: line 712
Called from D:/websites/Application.cfm: line 712
Called from D:/websites/Application.cfm: line 684
Called from D:/websites/Application.cfm: line 667
Called from D:/websites/Application.cfm: line 663
Called from D:/websites/Application.cfm: line 659
Called from D:/websites/Application.cfm: line 656
Called from D:/websites/Application.cfm: line 652
Called from D:/websites/Application.cfm: line 649
Called from D:/websites/Application.cfm: line 646
Called from D:/websites/Application.cfm: line 642
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.163.179.108
Referrer  
Date/Time   31-Jan-15 01:17 PM
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:739) at cfApplication2ecfm1527249024._factor5(D:/websites/Application.cfm:722) at cfApplication2ecfm1527249024._factor51(D:/websites/Application.cfm:712) at cfApplication2ecfm1527249024._factor52(D:/websites/Application.cfm:712) at cfApplication2ecfm1527249024._factor53(D:/websites/Application.cfm:684) at cfApplication2ecfm1527249024._factor54(D:/websites/Application.cfm:667) at cfApplication2ecfm1527249024._factor55(D:/websites/Application.cfm:663) at cfApplication2ecfm1527249024._factor56(D:/websites/Application.cfm:659) at cfApplication2ecfm1527249024._factor57(D:/websites/Application.cfm:656) at cfApplication2ecfm1527249024._factor58(D:/websites/Application.cfm:652) at cfApplication2ecfm1527249024._factor59(D:/websites/Application.cfm:649) at cfApplication2ecfm1527249024._factor60(D:/websites/Application.cfm:646) at cfApplication2ecfm1527249024._factor71(D:/websites/Application.cfm:642) 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:739) at cfApplication2ecfm1527249024._factor5(D:/websites/Application.cfm:722) at cfApplication2ecfm1527249024._factor51(D:/websites/Application.cfm:712) at cfApplication2ecfm1527249024._factor52(D:/websites/Application.cfm:712) at cfApplication2ecfm1527249024._factor53(D:/websites/Application.cfm:684) at cfApplication2ecfm1527249024._factor54(D:/websites/Application.cfm:667) at cfApplication2ecfm1527249024._factor55(D:/websites/Application.cfm:663) at cfApplication2ecfm1527249024._factor56(D:/websites/Application.cfm:659) at cfApplication2ecfm1527249024._factor57(D:/websites/Application.cfm:656) at cfApplication2ecfm1527249024._factor58(D:/websites/Application.cfm:652) at cfApplication2ecfm1527249024._factor59(D:/websites/Application.cfm:649) at cfApplication2ecfm1527249024._factor60(D:/websites/Application.cfm:646) at cfApplication2ecfm1527249024._factor71(D:/websites/Application.cfm:642) 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:739)
	at cfApplication2ecfm1527249024._factor5(D:\websites\Application.cfm:722)
	at cfApplication2ecfm1527249024._factor51(D:\websites\Application.cfm:712)
	at cfApplication2ecfm1527249024._factor52(D:\websites\Application.cfm:712)
	at cfApplication2ecfm1527249024._factor53(D:\websites\Application.cfm:684)
	at cfApplication2ecfm1527249024._factor54(D:\websites\Application.cfm:667)
	at cfApplication2ecfm1527249024._factor55(D:\websites\Application.cfm:663)
	at cfApplication2ecfm1527249024._factor56(D:\websites\Application.cfm:659)
	at cfApplication2ecfm1527249024._factor57(D:\websites\Application.cfm:656)
	at cfApplication2ecfm1527249024._factor58(D:\websites\Application.cfm:652)
	at cfApplication2ecfm1527249024._factor59(D:\websites\Application.cfm:649)
	at cfApplication2ecfm1527249024._factor60(D:\websites\Application.cfm:646)
	at cfApplication2ecfm1527249024._factor71(D:\websites\Application.cfm:642)
	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)