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 'Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIK' at line 3
|
| |
The error occurred in D:/www/Starter/icinyc.com/httpdocs/v2/search.cfm: line 96
Called from D:/www/Starter/icinyc.com/httpdocs/v2/index.cfm: line 328
Called from D:/www/Starter/icinyc.com/httpdocs/v2/search.cfm: line 96
Called from D:/www/Starter/icinyc.com/httpdocs/v2/index.cfm: line 328
|
94 : <cfif itemnum neq ""><cfloop list="#Replace(itemnum,' ',',','All')#" index="count"> AND (ItemNumber LIKE ('%#count#%') OR Title LIKE ('%#count#%') OR Collection LIKE ('%#count#%') OR Category LIKE ('%#count#%') OR Weave LIKE ('%#count#%') OR Pattern LIKE ('%#count#%') OR Print LIKE ('%#count#%') OR Features LIKE ('%#count#%') OR Origin LIKE ('%#count#%') OR WebDescription LIKE ('%#count#%') OR Category2 LIKE ('%#count#%'))</cfloop></cfif>
95 : <cfif weightf neq "" AND weightt neq ""> AND WeightGM >= #weightf# AND WeightGM <= #weightt#</cfif>
96 : <cfif new eq 1>order by DateEntered DESC<cfelseif sort eq "">order by Priority DESC,DateMarkedNew DESC,ItemNumber DESC<cfelse>order by #sort#</cfif>
97 : </cfquery>
98 :
|
|
| SQLSTATE |
42000 |
| DATASOURCE |
A5057_zentex |
| VENDORERRORCODE |
1064 |
| SQL |
SELECT * from inventory
WHERE View = 0
AND Collection LIKE ('%CLEARANCE%') AND (Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%') OR Weave LIKE ('%TAFFETA / PLAIN WEAVE%') OR Weave LIKE ('%RIB%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%') OR Weave LIKE ('%TAFFETA / PLAIN WEAVE%') OR Weave LIKE ('%DOBBYS / PIQUES%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%') OR Weave LIKE ('%TAFFETA / PLAIN WEAVE%') OR Weave LIKE ('%RIB%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%') OR Weave LIKE ('%TAFFETA / PLAIN WEAVE%') OR Weave LIKE ('%NON WOVEN%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%') OR Weave LIKE ('%TAFFETA / PLAIN WEAVE%') OR Weave LIKE ('%RIB%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%') OR Weave LIKE ('%TAFFETA / PLAIN WEAVE%') OR Weave LIKE ('%DOBBYS / PIQUES%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%') OR Weave LIKE ('%TAFFETA / PLAIN WEAVE%') OR Weave LIKE ('%RIB%')Weave LIKE ('%GAUZE / VOILE / LAWN%') OR Weave LIKE ('%JACQUARDS%') OR Weave LIKE ('%MESH / TRICOTS%') OR Weave LIKE ('%TAFFETA / PLAIN WEAVE%')) AND (Features LIKE ('%ECO FRIENDLY | SUSTAINABLE%')Features LIKE ('%ECO FRIENDLY | SUSTAINABLE%') OR Features LIKE ('%OPAQUE / NON TRANSPARENT%')) AND (Category LIKE ('%NYLON AND NYLON BLENDS%')) AND (Collection LIKE ('%Linings%') OR Collection LIKE ('%Fusible Interlinings%')) order by DateEntered DESC |
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
172.31.42.155 |
| Referrer |
|
| Date/Time |
06-Aug-24 07:21 PM |
|
