getProducts
getProducts
<cfcomponent>
<cffunction name="getProducts" returnType="query" access="remote" output ="no">
<cfargument name="ProductName" type="string" required="true">
<cfquery name="prosearch" datasource="icf" dbtype="ODBC">
SELECT Product.ProductID, Product.ProductName, Product.ProductPricePerUnit, Product.VendorID
FROM Product
WHERE Product.ProductName LIKE '#arguments.ProductName#%'
</cfquery>
<cfreturn #prosearch#>
</cffunction>
</cfcomponent>
Previous slide
Next slide
Back to first slide
View graphic version
Home
Speakers
Directions
Schedule
Photos
CF Conf Central
Please send comments/questions to
[email protected]