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 'inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')i' at line 4
|
| |
The error occurred in D:/www/Starter/zentextiles.com/httpdocs/v2/search.cfm: line 159
Called from D:/www/Starter/zentextiles.com/httpdocs/v2/search.cfm: line 125
Called from D:/www/Starter/zentextiles.com/httpdocs/v2/search.cfm: line 1
Called from D:/www/Starter/zentextiles.com/httpdocs/v2/index.cfm: line 503
Called from D:/www/Starter/zentextiles.com/httpdocs/v2/search.cfm: line 159
Called from D:/www/Starter/zentextiles.com/httpdocs/v2/search.cfm: line 125
Called from D:/www/Starter/zentextiles.com/httpdocs/v2/search.cfm: line 1
Called from D:/www/Starter/zentextiles.com/httpdocs/v2/index.cfm: line 503
|
157 : <cfif weightf neq "" AND weightt neq ""> AND inventory.WeightGM >= #weightf# AND inventory.WeightGM <= #weightt#</cfif>
158 : <cfif widthf neq "" AND widtht neq ""> AND inventory.Width >= #widthf# AND inventory.Width <= #widtht#</cfif>
159 : <cfif new eq 1>order by inventory.DateEntered DESC<cfelseif sort eq "">order by inventory.Collection,inventory.Priority DESC,inventory.DateMarkedNew DESC,inventory.DateEntered DESC<cfelse>order by inventory.#sort#</cfif>
160 : </cfquery>
161 :
|
|
| SQLSTATE |
42000 |
| DATASOURCE |
A5057_zentex |
| VENDORERRORCODE |
1064 |
| SQL |
SELECT *
FROM inventory
WHERE inventory.View = 0
AND (inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%') OR inventory.Weave LIKE ('%FLEECE%') OR inventory.Weave LIKE ('%TRICOTS%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%') OR inventory.Weave LIKE ('%FLEECE%') OR inventory.Weave LIKE ('%GABARDINE%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%') OR inventory.Weave LIKE ('%FLEECE%') OR inventory.Weave LIKE ('%TRICOTS%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%') OR inventory.Weave LIKE ('%FLEECE%') OR inventory.Weave LIKE ('%SHEETING%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%') OR inventory.Weave LIKE ('%FLEECE%') OR inventory.Weave LIKE ('%TRICOTS%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%') OR inventory.Weave LIKE ('%FLEECE%') OR inventory.Weave LIKE ('%GABARDINE%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%') OR inventory.Weave LIKE ('%FLEECE%') OR inventory.Weave LIKE ('%TRICOTS%')inventory.Weave LIKE ('%CREPE BACK SATIN%') OR inventory.Weave LIKE ('%SATIN%') OR inventory.Weave LIKE ('%FLEECE%')) AND (inventory.Features LIKE ('%COOL TOUCH%')) AND (inventory.BrandedFiber LIKE ('%CATLIGHT%') OR inventory.BrandedFiber LIKE ('%COOLMAX%') OR inventory.BrandedFiber LIKE ('%LENZING /MODAL TENCEL LYOCELL%')) AND (inventory.Category LIKE ('%Cotton%') OR inventory.Category LIKE ('%LINEN FLAX AND LINEN BLENDS%')) AND (inventory.Collection LIKE ('%CELLULOSE /TENCEL / LYOCELL%')) order by inventory.Collection,inventory.Priority DESC,inventory.DateMarkedNew DESC,inventory.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 06:23 PM |
|
