Re: One More Stupid Query Question

On Aug 17, 2004, at 11:42 PM, Les Mizzell wrote: SELECT * FROM news_pr Where Headline like '%#var1#%' or BodyText like '%#var2#%' or tagline like '%#var3#%' and pr_status='Active' and Year(pr_date) = #FORM.pubDATE# order by pr_date desc Make sure you are cleaning those variables before you

Re: One More Stupid Query Question

Les Mizzell wrote: SELECT * FROM news_pr Where Headline like '%#var1#%' or BodyText like '%#var2#%' or tagline like '%#var3#%' and pr_status='Active' and Year(pr_date) = #FORM.pubDATE# order by pr_date desc However, if I enter 1998 in the form, it's still returning results from

One More Stupid Query Question

Here's what I'm using... SELECT * FROM news_pr Where Headline like '%#var1#%' or BodyText like '%#var2#%' or tagline like '%#var3#%' and pr_status='Active' and Year(pr_date) = #FORM.pubDATE# order by pr_date desc However, if I enter 1998 in the form, it's still returning results from other

RE: One More Stupid Query Question

PROTECTED] Sent: Tuesday, August 17, 2004 11:43 PM To: CF-Talk Subject: One More Stupid Query Question Here's what I'm using... SELECT * FROM news_pr Where Headline like '%#var1#%' or BodyText like '%#var2#%' or tagline like '%#var3#%' and pr_status='Active' and Year(pr_date) = #FORM.pubDATE# order