<cfcomponent displayName="SearchProducts">
<cffunction name="getSearchResult" access="remote"
returnType="query">
<cfargument name="search" type="string"
default="%">
<cfquery name="rsGetProducts"
datasource="Northwind">
SELECT ProductName, UnitPrice, QuantityPerUnit
FROM Products
WHERE ProductName LIKE '%#search#%'
</cfquery>
<cfreturn rsGetProducts>
</cffunction>
</cfcomponent>