Sort by Category
   Bracelets
  Earrings
  Necklaces
  Pendants
  Rings
Sort by Gem Color
  Show All
  Amethyst
  Black Diamond
  Blue Topaz
  Brown Diamond
  Diamond
  Emerald
  Garnet
  Multi-color Sapphires
  Opal
  Pearl
  Peridot
  Pink Sapphire
  Pink Tourmaline
  Rose Amethyst
  Ruby
  Sapphire
   Tanzanite
Sort by Gem Shape
  Show All
  Baguette
  Cabochon
  Clover
  Cushion
  Emerald Cut
  Marquise
  Oval
  Pear Shape
  Princess
   Round
Sort by Metal
  Show All
  Rose Gold
  White Gold
  Yellow Gold
Sort by Carat Weight
  Show All
  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
Sort by Price Range
  Show All
  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 '?group=line AND OurPrice <= AND DiaTCW >= 3.00 AND DiaTCW <= 100.00 order by Pr' at line 2
 
The error occurred in D:/www/Corporate/ryangems.com/httpdocs/v2/search.cfm: line 80
Called from D:/www/Corporate/ryangems.com/httpdocs/v2/index.cfm: line 581
Called from D:/www/Corporate/ryangems.com/httpdocs/v2/search.cfm: line 80
Called from D:/www/Corporate/ryangems.com/httpdocs/v2/index.cfm: line 581
 
78 : 	SELECT * from inventory
79 : 	WHERE View = 1<cfif new eq 1> AND NewArrival = 1</cfif><cfif clear eq 1> AND Clearance = 1</cfif><cfif best eq 1> AND BestSeller = 1</cfif><cfif inv neq ""> AND RGInventory = 1</cfif><cfif show neq ""> AND RGShow = 1</cfif><cfif line neq ""> AND RGLine = 1</cfif><cfif coll neq ""> AND Collection = '#coll#'</cfif><cfif designer neq ""> AND Designers = '#designer#'</cfif><cfif cat neq ""> AND Category = '#ucase(cat)#'</cfif><cfif subcat neq ""> AND SubCategory = '#subcat#'</cfif><cfif itemnum neq ""> AND (ItemNumber LIKE ('%#itemnum#%') OR StyleCode LIKE ('%#itemnum#%') OR Title LIKE ('%#itemnum#%'))</cfif><cfif metl neq ""><cfif NOT Find("/",metl,1)> AND (Metal LIKE '%#LEFT(metl,3)#%') AND (Metal LIKE '%#Mid(metl,5,Len(metl))#%')<cfelse> AND Metal = '#metl#'</cfif></cfif><cfif stonecolor neq ""> AND GemCategory = '#stonecolor#'</cfif><cfif stoneshape neq ""> AND GemShape = '#stoneshape#'</cfif><cfif prange neq ""> AND OurPrice >= #GetToken(prange,1,"|")# AND OurPrice <= #GetToken(prange,2,"|")#</cfif><cfif tcw neq ""> AND DiaTCW >= #GetToken(tcw,1,"|")# AND DiaTCW <= #GetToken(tcw,2,"|")#</cfif>
80 : 	<cfif sort neq "">order by #sort#</cfif>
81 : 	</cfquery>
82 :
SQLSTATE   42000
DATASOURCE   A5057_ryangems
VENDORERRORCODE   1064
SQL    SELECT * from inventory WHERE View = 1 AND Category = 'BRACELETS' AND GemCategory = 'TANZANITE' AND GemShape = 'ROUND' AND OurPrice >= ∏group=line AND OurPrice <= AND DiaTCW >= 3.00 AND DiaTCW <= 100.00 order by Priority DESC, ItemNumber DESC
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   172.31.67.125
Referrer  
Date/Time   05-Jun-24 10:32 AM
Stack Trace
at cfsearch2ecfm1763259339.runPage(D:/www/Corporate/ryangems.com/httpdocs/v2/search.cfm:80) at cfindex2ecfm1073461961.runPage(D:/www/Corporate/ryangems.com/httpdocs/v2/index.cfm:581) at cfsearch2ecfm1763259339.runPage(D:/www/Corporate/ryangems.com/httpdocs/v2/search.cfm:80) at cfindex2ecfm1073461961.runPage(D:/www/Corporate/ryangems.com/httpdocs/v2/index.cfm:581) 

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 '?group=line AND OurPrice <=  AND DiaTCW >= 3.00 AND DiaTCW <= 100.00 order by Pr' at line 2
	at jdk.internal.reflect.GeneratedConstructorAccessor6301.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 cfsearch2ecfm1763259339.runPage(D:\www\Corporate\ryangems.com\httpdocs\v2\search.cfm:80)
	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 cfindex2ecfm1073461961.runPage(D:\www\Corporate\ryangems.com\httpdocs\v2\index.cfm:581)
	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)