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:297923
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
