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#%)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 2:14 PM
To: CF-Newbie
Subject: Help with Query
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]
