Sort by Category
  Bracelets
   Earrings
  Necklaces
  Pendants
  Rings
Sort by Gem Color
  Show All
  Amethyst
  Aqua
  Black Diamond
  Blue Diamond
  Blue Topaz
  Brown Diamond
  Citrine
  Cognac Quartz
  Diamond
  Emerald
  Garnet
  Green Amethyst
  Iolite
  Lemon Quartz
  Morganite
  Multi-color Sapphires
  Multicolored Sapphire
   Opal
  Pearl
  Peridot
  Pink Sapphire
  Pink Tourmaline
  Rhodolite
  Rose Amethyst
  Ruby
  Sapphire
  Smokey Topaz
  Tanzanite
  Yellow Quartz
Sort by Gem Shape
  Show All
  Baguette
  Ball
  Clover
  Cushion
  Emerald Cut
  Heart Shape
  Marquise
   Oval
  Pear Shape
  Princess
  Round
  Trillion
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 <= order by Priority DESC, ItemNumber DESC' 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 = 'EARRINGS' AND (Metal LIKE '%ROS%') AND (Metal LIKE '% Gold%') AND GemCategory = 'OPAL' AND GemShape = 'OVAL' AND OurPrice >= ∏group=line AND OurPrice <= 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:13 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 <= order by Priority DESC, ItemNumber DESC' 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)