<cfquery dbtype="odbc" datasource="ssimain.mdb" name="search">
select *
from items
WHERE prod_group = '#form.area#' AND
item_name like '%#form.searchon#%' or
comments like '%#form.searchon#%' or
apps_market like '%#form.searchon#%' or
prod_category like '%#form.searchon#%' or
main_category like '%#form.searchon#%'
</cfquery>
is returning values where prod_group is NOT form.area ?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
