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 ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventor' 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.ItemNumber = 'JN2490' OR inventory.ItemNumber = 'JS41237' OR inventory.ItemNumber = 'JN919' OR inventory.ItemNumber = 'JS13466' OR inventory.ItemNumber = 'JS22409' OR inventory.ItemNumber = 'JS41243' OR inventory.ItemNumber = 'JN2540' OR inventory.ItemNumber = 'JN916' OR inventory.ItemNumber = 'JS22457' OR inventory.ItemNumber = 'JS41256' OR inventory.ItemNumber = 'CFWR10028-1' OR inventory.ItemNumber = 'JN29000' OR inventory.ItemNumber = 'JS13131' OR inventory.ItemNumber = 'JS22448' OR inventory.ItemNumber = 'JS41238' OR inventory.ItemNumber = 'JS41260' OR inventory.ItemNumber = 'JN30000' OR inventory.ItemNumber = 'JN70081' OR inventory.ItemNumber = 'JN7309' OR inventory.ItemNumber = 'JS11452' OR inventory.ItemNumber = 'JS22203' OR inventory.ItemNumber = 'JS52195' OR inventory.ItemNumber = 'jn10614' OR inventory.ItemNumber = 'JN1236' OR inventory.ItemNumber = 'JN1266' OR inventory.ItemNumber = 'JN7406' OR inventory.ItemNumber = 'JS13456' OR inventory.ItemNumber = 'JS14346' OR inventory.ItemNumber = 'JS22146' OR inventory.ItemNumber = 'JS22443' OR inventory.ItemNumber = 'JS52345' OR inventory.ItemNumber = 'JN1260' OR inventory.ItemNumber = 'JN17000' OR inventory.ItemNumber = 'JN64500' OR inventory.ItemNumber = 'JN7426' OR inventory.ItemNumber = 'JN914' OR inventory.ItemNumber = 'JN915' OR inventory.ItemNumber = 'JN926' OR inventory.ItemNumber = 'JS11484' OR inventory.ItemNumber = 'JS52344' OR inventory.ItemNumber = 'JN7700' OR inventory.ItemNumber = 'JS11490' OR inventory.ItemNumber = 'JS11501' OR inventory.ItemNumber = 'JS13248' OR inventory.ItemNumber = 'JS13293' OR inventory.ItemNumber = 'JS14186' OR inventory.ItemNumber = 'JS22111' OR inventory.ItemNumber = 'JS22277' OR inventory.ItemNumber = 'JS41118' OR inventory.ItemNumber = 'JS52333' OR inventory.ItemNumber = 'JS52334' OR inventory.ItemNumber = 'JS75500' OR inventory.ItemNumber = 'JN111-A' OR inventory.ItemNumber = 'JN1250' OR inventory.ItemNumber = 'JN1265' OR inventory.ItemNumber = 'JN1510' OR inventory.ItemNumber = 'JN18000' OR inventory.ItemNumber = 'JN46500' OR inventory.ItemNumber = 'JN701' OR inventory.ItemNumber = 'JS11504' OR inventory.ItemNumber = 'JS14389' OR inventory.ItemNumber = 'JS35386' OR inventory.ItemNumber = 'JS41244' OR inventory.ItemNumber = 'JS52181' OR inventory.ItemNumber = 'JS52327' OR inventory.ItemNumber = 'JS52346' OR inventory.ItemNumber = 'JS9106' OR inventory.ItemNumber = 'JSBCN666' OR inventory.ItemNumber = 'JN12000' OR inventory.ItemNumber = 'JN1247' OR inventory.ItemNumber = 'JN1261' OR inventory.ItemNumber = 'JN1611' OR inventory.ItemNumber = 'jn24000' OR inventory.ItemNumber = 'JN25000' OR inventory.ItemNumber = 'JN3420' OR inventory.ItemNumber = 'JN749' OR inventory.ItemNumber = 'JN7592' OR inventory.ItemNumber = 'JN913' OR inventory.ItemNumber = 'JS11503' OR inventory.ItemNumber = 'JS14280' OR inventory.ItemNumber = 'JS14295' OR inventory.ItemNumber = 'JS26234' OR inventory.ItemNumber = 'JS35486' OR inventory.ItemNumber = 'JS41210' OR inventory.ItemNumber = 'JS43128' OR inventory.ItemNumber = 'JS52317' OR inventory.ItemNumber = 'JS52323' OR inventory.ItemNumber = 'CFWR10028-4' OR inventory.ItemNumber = 'JN10612' OR inventory.ItemNumber = 'jn1115' OR inventory.ItemNumber = 'JN1269' OR inventory.ItemNumber = 'JN1271' OR inventory.ItemNumber = 'JN1502' OR inventory.ItemNumber = 'jn2465' OR inventory.ItemNumber = 'JN3900' OR inventory.ItemNumber = 'JN479-A' OR inventory.ItemNumber = 'JN70041' OR inventory.ItemNumber = 'JN709Z' OR inventory.ItemNumber = 'JN7388' OR inventory.ItemNumber = 'JN762' OR inventory.ItemNumber = 'jn763' OR inventory.ItemNumber = 'JN917' OR inventory.ItemNumber = 'JN9211' OR inventory.ItemNumber = 'JS11133' OR inventory.ItemNumber = 'JS12481' OR inventory.ItemNumber = 'JS13460' OR inventory.ItemNumber = 'JS13673' OR inventory.ItemNumber = 'js14200' OR inventory.ItemNumber = 'JS22466' OR inventory.ItemNumber = 'JS26247' OR inventory.ItemNumber = 'JS35331' OR inventory.ItemNumber = 'JS35483' OR inventory.ItemNumber = 'JS41034' OR inventory.ItemNumber = 'JS52193' OR inventory.ItemNumber = 'CF50477' OR inventory.ItemNumber = 'jn10613' OR inventory.ItemNumber = 'JN1231' OR inventory.ItemNumber = 'JN1262' OR inventory.ItemNumber = 'JN1272' OR inventory.ItemNumber = 'JN2310' OR inventory.ItemNumber = 'JN33000' OR inventory.ItemNumber = 'JN45301' OR inventory.ItemNumber = 'JN515' OR inventory.ItemNumber = 'JN5364' OR inventory.ItemNumber = 'JN5382' OR inventory.ItemNumber = 'JN55402' OR inventory.ItemNumber = 'jn6811' OR inventory.ItemNumber = 'JN7390' OR inventory.ItemNumber = 'JN923' OR inventory.ItemNumber = 'JN931' OR inventory.ItemNumber = 'js11263' OR inventory.ItemNumber = 'JS11450' OR inventory.ItemNumber = 'JS11659' OR inventory.ItemNumber = 'JS13029' OR inventory.ItemNumber = 'JS13467' OR inventory.ItemNumber = 'JS14187' OR inventory.ItemNumber = 'JS14199' OR inventory.ItemNumber = 'JS14276' OR inventory.ItemNumber = 'JS14379' OR inventory.ItemNumber = 'JS14380' OR inventory.ItemNumber = 'JS14386' OR inventory.ItemNumber = 'JS14388' OR inventory.ItemNumber = 'JS22481' OR inventory.ItemNumber = 'JS26236' OR inventory.ItemNumber = 'JS26238' OR inventory.ItemNumber = 'JS35468' OR inventory.ItemNumber = 'JS43151' OR inventory.ItemNumber = 'JS43878' OR inventory.ItemNumber = 'JS52062' OR inventory.ItemNumber = 'JS52305' OR inventory.ItemNumber = 'JS76079' OR inventory.ItemNumber = 'CF50502' OR inventory.ItemNumber = 'CF99452' OR inventory.ItemNumber = 'CFWR10028-2' OR inventory.ItemNumber = 'JN1010' OR inventory.ItemNumber = 'JN10609' OR inventory.ItemNumber = 'JN114-A' OR inventory.ItemNumber = 'JN117-A' OR inventory.ItemNumber = 'JN1253' OR inventory.ItemNumber = 'JN159-A' OR inventory.ItemNumber = 'JN2100' OR inventory.ItemNumber = 'JN29900' OR inventory.ItemNumber = 'JN352-A' OR inventory.ItemNumber = 'JN354-A' OR inventory.ItemNumber = 'JN45300' OR inventory.ItemNumber = 'JN46100' OR inventory.ItemNumber = 'JN485-A' OR inventory.ItemNumber = 'JN6831' OR inventory.ItemNumber = 'jn7326' OR inventory.ItemNumber = 'JN74200' OR inventory.ItemNumber = 'JN748' OR inventory.ItemNumber = 'JN752' OR inventory.ItemNumber = 'JN7593' OR inventory.ItemNumber = 'jn7801' OR inventory.ItemNumber = 'JN789' OR inventory.ItemNumber = 'JN80550' OR inventory.ItemNumber = 'JN912' OR inventory.ItemNumber = 'JNV1713' OR inventory.ItemNumber = 'JS11264' OR inventory.ItemNumber = 'JS11301' OR inventory.ItemNumber = 'JS12105' OR inventory.ItemNumber = 'JS12177' OR inventory.ItemNumber = 'JS12383' OR inventory.ItemNumber = 'JS13247' OR inventory.ItemNumber = 'JS13461' OR inventory.ItemNumber = 'JS14111' OR inventory.ItemNumber = 'JS14117' OR inventory.ItemNumber = 'JS14254' OR inventory.ItemNumber = 'JS14293' OR inventory.ItemNumber = 'JS14395' OR inventory.ItemNumber = 'JS22482' OR inventory.ItemNumber = 'JS22483' OR inventory.ItemNumber = 'js35180' OR inventory.ItemNumber = 'JS35477' OR inventory.ItemNumber = 'JS35493' OR inventory.ItemNumber = 'JS41153' OR inventory.ItemNumber = 'JS41187' OR inventory.ItemNumber = 'JS41612' OR inventory.ItemNumber = 'JS41673' OR inventory.ItemNumber = 'JS43420' OR inventory.ItemNumber = 'JS52313' OR inventory.ItemNumber = 'JS52328' OR inventory.ItemNumber = 'JS76365' OR inventory.ItemNumber = 'JSBCN1096' OR inventory.ItemNumber = 'JSBCN1135' OR inventory.ItemNumber = 'JSBCN952SOLID' OR inventory.ItemNumber = 'CFWR10028-3' OR inventory.ItemNumber = 'JN1205' OR inventory.ItemNumber = 'JN1232' OR inventory.ItemNumber = 'jn1267' OR inventory.ItemNumber = 'JN1330' OR inventory.ItemNumber = 'JN143-A' OR inventory.ItemNumber = 'JN1503' OR inventory.ItemNumber = 'JN160-A' OR inventory.ItemNumber = 'JN17200' OR inventory.ItemNumber = 'JN2160' OR inventory.ItemNumber = 'JN2413' OR inventory.ItemNumber = 'JN2424' OR inventory.ItemNumber = 'JN2444' OR inventory.ItemNumber = 'JN2663' OR inventory.ItemNumber = 'JN2675' OR inventory.ItemNumber = 'JN28000' OR inventory.ItemNumber = 'jn2902' OR inventory.ItemNumber = 'JN401-A' OR inventory.ItemNumber = 'JN406-A' OR inventory.ItemNumber = 'JN508' OR inventory.ItemNumber = 'JN5780' OR inventory.ItemNumber = 'JN6250' OR inventory.ItemNumber = 'JN68010' OR inventory.ItemNumber = 'JN68225Z' OR inventory.ItemNumber = 'JN6825' OR inventory.ItemNumber = 'JN7316' OR inventory.ItemNumber = 'JN7357' OR inventory.ItemNumber = 'JN7565' OR inventory.ItemNumber = 'JN764' OR inventory.ItemNumber = 'JN769' OR inventory.ItemNumber = 'JN88190' OR inventory.ItemNumber = 'JS11276' OR inventory.ItemNumber = 'JS11277' OR inventory.ItemNumber = 'JS11395' OR inventory.ItemNumber = 'JS11453' OR inventory.ItemNumber = 'JS11485' OR inventory.ItemNumber = 'JS11489' OR inventory.ItemNumber = 'JS11537' OR inventory.ItemNumber = 'JS11712' OR inventory.ItemNumber = 'JS12085' OR inventory.ItemNumber = 'JS12756' OR inventory.ItemNumber = 'js12768' OR inventory.ItemNumber = 'JS13256' OR inventory.ItemNumber = 'JS14152') AND (inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%') OR inventory.Weave LIKE ('%CHAMBRAY%') OR inventory.Weave LIKE ('%SATEEN%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%') OR inventory.Weave LIKE ('%CHAMBRAY%') OR inventory.Weave LIKE ('%PONTE%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%') OR inventory.Weave LIKE ('%CHAMBRAY%') OR inventory.Weave LIKE ('%SATEEN%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%') OR inventory.Weave LIKE ('%CHAMBRAY%') OR inventory.Weave LIKE ('%DENIM%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%') OR inventory.Weave LIKE ('%CHAMBRAY%') OR inventory.Weave LIKE ('%SATEEN%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%') OR inventory.Weave LIKE ('%CHAMBRAY%') OR inventory.Weave LIKE ('%PONTE%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%') OR inventory.Weave LIKE ('%CHAMBRAY%') OR inventory.Weave LIKE ('%SATEEN%')inventory.Weave LIKE ('%TAFFETA%') OR inventory.Weave LIKE ('%HOPSACK%') OR inventory.Weave LIKE ('%CHAMBRAY%')) AND (inventory.Features LIKE ('%METALLIC%')inventory.Features LIKE ('%METALLIC%') OR inventory.Features LIKE ('%QUICK DRY / WICKING%')) AND (inventory.Category LIKE ('%Cotton%')) AND (inventory.Collection LIKE ('%ORGANIC/RECYCLED%') OR inventory.Collection LIKE ('%WOOLEN%')) 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.3.58 |
Referrer |
|
Date/Time |
06-Aug-24 09:04 PM |
|