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 :
|