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
On Feb 1, 2008 10:15 AM, Ali <[EMAIL PROTECTED]> wrote:
> I need to make a search function for my site. I wonder if it is
> possible to search for multi-word combinations which it searches each
> word
> individually and the words get sepereated by the user by SPACE " ". I
> wrote something using cfloop but it doesn't work. Please tell me
> what's
> wrong with my code. If you know a better way to make a search function
> that users can actually write several words in the search field and
> the
> search function searches for each word and ignores the space in
> between.
> Thanks
> Benign
>
> This is my code:
>
> <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>
> )
> 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:297934
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
