On Feb 1, 2008 9:57 PM, Gerald Guido <[EMAIL PROTECTED]> wrote: > Your list is missing #'s > > list="FORM.SEARCHFORM" > > Should be > > list="#FORM.SEARCHFORM#" > > > > The following will fix the OR issue. Notice the "1=0" at the end which > will > return zero results. > > > <cfloop index="URL.SEARCH" list="#FORM.SEARCHFORM#" delimiters=" "> > Products.ProductName LIKE '%#URL.SEARCH#%' > OR > Companies.CompanyName LIKE '%#URL.SEARCH#%' > OR > </cfloop> > 1=0 > > --------------- > > This will return: > > Products.ProductName LIKE '%technologies%' > OR > Companies.CompanyName LIKE '%technologies%' > OR > Products.ProductName LIKE '%safety%' > OR > Companies.CompanyName LIKE '%safety%' > OR > 1=0 > > > I did as you said: But it didn't work! I copied the edited code below. I > put ## around list="#FORM.SEARCHFORM#" and I put the 1=0 to stop the > missing OR from happening. It stills returns nothing even when I type one > word!!! Please help me. > Thanks Benign
> <cfparam name="FORM.SEARCHFORM" type="any" default=""> > <cfparam name="url.search" default="" type="any"> > <cfquery name="search" datasource="search"> > Select > CompanyTypes.CompanyTypeID, > CompanyTypes.CompanyTypeName, > CompanyTypes.CompanyTypeDesc, > CompanyTypes.CompanyTypeImage, > Companies.CompanyID, > Companies.CompanyName, > Companies.ManagerName, > Companies.SalesManagerName, > Companies.CompanyCity, > Companies.CompanyAdd, > Companies.CompanyDesc, > Companies.CompanyRank, > Companies.CompanyTypeID, > Products.ProductID, > Products.ProductName, > Products.ProductDesc, > Products.ProductImage, > Products.ProductTypeID, > Companies_Products.Companies_ProductsID, > Companies_Products.CompanyID, > Companies_Products.ProductID > From > CompanyTypes, > Companies, > Products, > Companies_Products > Where ( > CompanyTypes.CompanyTypeID = Companies.CompanyTypeID > And Companies_Products.CompanyID = Companies.CompanyID > And Companies_Products.ProductID = Products.ProductID > ) > AND > ( <cfloop index="URL.SEARCH" list="#FORM.SEARCHFORM#" delimiters=" "> > Products.ProductName LIKE '%#URL.SEARCH#%' > OR > Companies.CompanyName LIKE '%#URL.SEARCH#%' > > </cfloop> > > 1=0 > ) > ORDER BY Companies.CompanyTypeID, Companies.CompanyRank ASC, > Companies.CompanyName ASC, Companies.CompanyID, Products.ProductID; > </cfquery> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
