Error Executing Database Query.
|
Unknown column 'StoneColor' in 'where clause'
|
|
The error occurred in D:/www/Starter/sjjewelrycorp.com/httpdocs/v4/v2/search.cfm: line 94
Called from D:/www/Starter/sjjewelrycorp.com/httpdocs/v4/v2/search.cfm: line 64
Called from D:/www/Starter/sjjewelrycorp.com/httpdocs/v4/v2/search.cfm: line 1
Called from D:/www/Starter/sjjewelrycorp.com/httpdocs/v4/v2/index.cfm: line 364
Called from D:/www/Starter/sjjewelrycorp.com/httpdocs/v4/v2/search.cfm: line 94
Called from D:/www/Starter/sjjewelrycorp.com/httpdocs/v4/v2/search.cfm: line 64
Called from D:/www/Starter/sjjewelrycorp.com/httpdocs/v4/v2/search.cfm: line 1
Called from D:/www/Starter/sjjewelrycorp.com/httpdocs/v4/v2/index.cfm: line 364
|
92 : <cfif isdefined("url.v") AND FindNoCase("Fana",url.v,1)> AND ItemNumber LIKE ('%White')</cfif>
93 : <cfif isdefined("url.v") AND FindNoCase("Fana",url.v,1)>group by ParentID</cfif>
94 : <cfif sort neq "">order by #sort#</cfif>
95 : </cfquery>
96 :
|
|
SQLSTATE |
42S22 |
DATASOURCE |
A5057_sjjewelry |
VENDORERRORCODE |
1054 |
SQL |
SELECT * from inventory
WHERE View = 1
AND StoneColor LIKE ('%Tanzanite,Diamond%') AND StoneShape LIKE ('%Princess,Round%')
AND OurPrice >= 0 AND OurPrice <= 999999
AND GemWeight >= 0 AND GemWeight <= 999 order by Priority DESC,NewArrival DESC,DateAdded DESC |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
172.31.65.244 |
Referrer |
|
Date/Time |
25-Apr-24 11:05 AM |
|