would ReplaceNoCase() work?
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- [EMAIL PROTECTED] ting.co.uk To: [EMAIL PROTECTED] cc: 16/03/2004 Subject: [ cf-dev ] coldfusion search 16:56 Please respond to dev Hi all, Im making a simple search engine as part of a university project with coldfusion and SQL, but Im having a little trouble. What I want is to highlight in bold the search term entered on the results page. I've managed to do this by reinserting the search term within bold tags, however this loses any uppercase letters. Eg. a name like Peter becomes peter. Is there a work-around for this? My query looks something like this: ------code------ <cfquery name=second datasource="tvheaven"> select * from tv_programmes where titlea like '%#searchterm#%' or description_prog like '%#searchterm#%' </cfquery> <cfoutput query=second> #replace(titlea, '[B]#searchterm#[/B]', 'ALL')# #replace(description_prog, '[B]#searchterm#[/B]', 'ALL')# </cfoutput> ---end code---- http://www.newaesthetik.com This message has been sent from CFdeveloper with username soleside ([EMAIL PROTECTED]) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
