[1] Did you try the brackets?
<cfquery name="news" datasource="mydsn">
select news.title, news.subtitle, news.dated, news.id, news.article
from news
where news.complete = 1
and (news.article like '#form.keywords#%'
or news.subtitle like '#form.keywords#%'
or news.title like '#form.keywords#%'
or news.keywords like '#form.keywords#%')
order by news.dated desc
</cfquery>
[2] the LIKE operator is really slow.
----- Original Message -----
From: "Kay Smoljak" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 31, 2000 10:51 PM
Subject: search query help
> Hi all,
>
> I have this simple search query that's perplexing me somewhat.
>
> <cfquery name="news" datasource="mydsn">
> select news.title, news.subtitle, news.dated, news.id, news.article
> from news
> where news.complete = 1
> and news.article like '#form.keywords#%'
> or news.subtitle like '#form.keywords#%'
> or news.title like '#form.keywords#%'
> or news.keywords like '#form.keywords#%'
> order by news.dated desc
> </cfquery>
>
> I've tried it a million different ways (well almost :) ) - this seems
> logical to me but it's not finding text that only appears in the
> news.article field. What am I missing?
>
> Regards,
> K.
> ______________________________________________________
> Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
> Internet Solutions for your business!
>
> Level 9/105 St George's Tc - Perth - Western Australia
> Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
> Visit Perth online! : www.perthweb.com.au
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
