prod_group AND itemname or comments or apps_market etc.
It is probably evaluating as such:
(prod_group AND item_name) or comments or app_market...
You probably want:
prod_group AND (item_name or comments or app_market...)
If so, put the parenthesis in yourself to make sure you know what is being grouped with what.
Does this help?
Jerry Johnson
>>> [EMAIL PROTECTED] 09/03/04 02:14PM >>>
Can anyone explain to me why this query:
<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]
