Sort by Type
  Bangles
  Bracelets
  Earrings
  Pendants
  Rings
Sort by Category
  Bolo Bracelets
  Classic Bangles
  Diamond Studs
  Diamonds By The Yard
  Fashion Bangles
  Fashion Bracelets
  Enamel
  Fashion Pendants
  Fashion Rings
  Gemstone Bracelets
  Huggies
  Initial Earrings
  Paperclip
  Tennis Bracelets
Sort by Carat Weight
  Up to 0.25ct
  0.25ct - 0.50ct
  0.50ct - 1.00ct
  1.00ct - 1.50ct
   1.50ct - 2.00ct
  2.00ct - 3.00ct
  3.00ct and up
  clear carat weight
Sort by Price Range
  Up to $500
  $500 to $1,000
  $1,000 to $2,000
  $2,000 to $3,000
  $3,000 to $4,000
  $4,000 to $5,000
  $5,000 and up

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.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND DiaTCW >= 1.50 AND DiaTCW <= 2.00 order by Priority DESC, OurPrice, ItemNu' at line 3
 
The error occurred in D:/www/Platinum/soferjewelry.com/httpdocs/v2/search.cfm: line 84
Called from D:/www/Platinum/soferjewelry.com/httpdocs/v2/index.cfm: line 708
Called from D:/www/Platinum/soferjewelry.com/httpdocs/v2/search.cfm: line 84
Called from D:/www/Platinum/soferjewelry.com/httpdocs/v2/index.cfm: line 708
 
82 : 		<cfif prange neq ""> AND OurPrice >= #GetToken(prange,1,"|")# AND OurPrice <= #GetToken(prange,2,"|")#</cfif>
83 : 		<cfif tcw neq ""> AND DiaTCW >= #GetToken(tcw,1,"|")# AND DiaTCW <= #GetToken(tcw,2,"|")#</cfif>
84 : 	order by #sortby#
85 : 	</cfquery>
86 :
SQLSTATE   42000
DATASOURCE   A5057_benysofer
VENDORERRORCODE   1064
SQL    SELECT * from inventory WHERE View = 1 AND Brand = '' AND BestSeller = 1 AND (SubCategory LIKE ('%2 Stone Necklaces,Bolo Bracelets,Circle%20Pendant,Cross Pendants,Diamond Studs,Drop Earrings,Earring Jackets,Fashion Bracelets,Fashion Earrings,Halo Necklaces,Halo Pendants,Initial Earrings%')) AND OurPrice >= 0%7C500 AND OurPrice <= AND DiaTCW >= 1.50 AND DiaTCW <= 2.00 order by Priority DESC, OurPrice, ItemNumber DESC
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   172.31.3.58
Referrer  
Date/Time   06-Aug-24 05:50 PM
Stack Trace
at cfsearch2ecfm843950162.runPage(D:/www/Platinum/soferjewelry.com/httpdocs/v2/search.cfm:84) at cfindex2ecfm1504568664.runPage(D:/www/Platinum/soferjewelry.com/httpdocs/v2/index.cfm:708) at cfsearch2ecfm843950162.runPage(D:/www/Platinum/soferjewelry.com/httpdocs/v2/search.cfm:84) at cfindex2ecfm1504568664.runPage(D:/www/Platinum/soferjewelry.com/httpdocs/v2/index.cfm:708) 

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND DiaTCW >= 1.50 AND DiaTCW <= 2.00
	order by Priority DESC, OurPrice, ItemNu' at line 3
	at jdk.internal.reflect.GeneratedConstructorAccessor94.newInstance(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:939)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cfsearch2ecfm843950162.runPage(D:\www\Platinum\soferjewelry.com\httpdocs\v2\search.cfm:84)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfindex2ecfm1504568664.runPage(D:\www\Platinum\soferjewelry.com\httpdocs\v2\index.cfm:708)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	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:60)
	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:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)