Copy link to clipboard
Copied
<cfquery datasource="yyyy" name="getData" >
SELECT Products.*, Categories.* FROM Products INNER JOIN Categories ON Categories.Category_ID = Products.Category_ID WHERE Category LIKE '%#searchKeyword#%' OR Product_ID LIKE '%#searchKeyword#%' OR Product_Name LIKE '%#searchKeyword#%' OR Product_Description LIKE '%#searchKeyword#%'
</cfquery>
SELECT queries in CFML needed to get closed at end of page?
In dreamweaver a simple template.dwt may accept cfml code, is needed renamed(ext)?
Copy link to clipboard
Copied
Under what circumstances does the error occur?
Copy link to clipboard
Copied
when #searchKeyword# get from url and contains spaces? if I url encode (how?), search still will work?