Re: Little help with a query please ... FIXED

2011-05-04 Thread Greg Morphis

I know it's late and all but what did you do differently?

Here's what you had earlier and looks the same.. lol Like I said.. it's late!

WHERE section <> 'news'

 AND (
  
   
   headline LIKE 
or content LIKE 
 OR 
   )

AND ( headline LIKE 
or content LIKE  )
   

On Wed, May 4, 2011 at 9:18 PM, Les Mizzell  wrote:
>
> This did the trick:
>
>
> WHERE section <> 'news'
>     
>      AND (
>       
>            
>        headline LIKE  cfsqltype="cf_sql_varchar">
>         or content LIKE  cfsqltype="cf_sql_varchar">
>          OR 
>        )
>     
>     AND ( headline LIKE  cfsqltype="cf_sql_varchar">
>     or content LIKE  cfsqltype="cf_sql_varchar"> )
>    
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344248
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Little help with a query please ... FIXED

2011-05-04 Thread Les Mizzell

This did the trick:


WHERE section <> 'news'
 
  AND (
   

headline LIKE 
 or content LIKE 
  OR 
)
 
 AND ( headline LIKE 
 or content LIKE  )


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344245
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm