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]
