I think this should work...
<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
(
<cfset listpos = 1>
<cfloop index="URL.SEARCH" list="#FORM.SEARCHFORM#" delimiters=" ">
(Products.ProductName LIKE '%#URL.SEARCH#%' OR
Companies.CompanyName LIKE '%#URL.SEARCH#%' )
<cfif listpos neq listlen(FORM.SEARCHFORM, " ")>
OR
</cfif>
<cfset listpos = listpos +1>
</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:297994
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
