search text bold

[Kamesh192]

Hi

I have a search query on my site and i wanted to know if theres a way of making the text searched for appear in bold in the results page??

any help would be useful
thanks
kamesh

[Stressed_Simon]

I assume that the field searched for is posted to the page from a form. So you
will have a variable something like this!

FORM.Search

You obviously use this in your SQL query to search the database. Then you
output the results to the page?

Well all you need to do then is put this somewhere.

<strrong><cfoutput>#FORM.Search#</cfoutput></strong>

[Kamesh192]

Hi
thanks simon,

i undersatand what u mean, the search funtion basically searches through our
database and brings up projects which the user search for. however on the
results page there is a description which appears too, now if the word search
for by the user appears in the descriptio then i want it bold?

the site is [url]www.pixelwork.com.index.cfm[/url] - the search feature is at the bottom
left hand side of the page
hope i ve explained myself well??

thanks
kamesh

[Stressed_Simon]

Here you go!

<cfset FORM.Search = "the">
<cfset FORM.Result = "This is the way to achieve the desired effect!">

<cfoutput>
<cfloop list="#FORM.Result#" index="ThisWord" delimiters=" ">
<cfif ListFindNoCase(FORM.Search, ThisWord, " ")>
<strong>#ThisWord#</strong>
<cfelse>
#ThisWord#
</cfif>
</cfloop>
</cfoutput>

[Kamesh192]

Hi

i ve changed the code (see below), ive change form.search to form.criteria as
that is what my box is called on the search page. now the word "the" comes up
in bold, however i want the word entered by the user to appear in bold. so
technically what ever the user enters in form.criteria i want that to appear in
bold.

<cfset FORM.criteria = "the">
<cfset FORM.Result = "This is the way to achieve the desired effect!">

<cfoutput>
<cfloop list="#FORM.Result#" index="ThisWord" delimiters=" ">
<cfif ListFindNoCase(FORM.criteria, ThisWord, " ")>
<strong>#ThisWord#</strong>
<cfelse>
#ThisWord#
</cfif>
</cfloop>
</cfoutput>

[Stressed_Simon]

OK, that was just to demonstrate the technique. To get it to work with the
return results, lets assume that your query is called qShowResults and the
field in your database is called Description. You have already said that the
search term is called Criteria.

Here is the code.

<cfoutput query="qShowResults">
<cfloop list="#Description#" index="ThisWord" delimiters=" ">
<cfif ListFindNoCase(FORM.Criteria, ThisWord, " ")>
<strong>#ThisWord#</strong>
<cfelse>
#ThisWord#
</cfif>
</cfloop>
</cfoutput>

[Kamesh192]

hi

great! it works!

thanks for your help simon, there was one more question im trying to put in a
break (<br>) after description, so there is some space between records. but i
get error when i put the <br> after description. the error says "Invalid CFML
construct found on line 206 at column 35.
ColdFusion was looking at the following text: " , "

below is the code im using
<cfoutput query="search">
<a
href="workDetail.cfm?projectID=#search.projectID#& catID=#search.catID#">#Project
Name#</a><br>
<cfloop list="#(search.Description,<br>100)#..." index="ThisWord" delimiters="
">
<cfif ListFindNoCase(FORM.Criteria, ThisWord, " ")>
<strong>#ThisWord#</strong>
<cfelse>
#ThisWord#
</cfif>
</cfloop>
</cfoutput>


thanks agin for your help
kamesh

[Stressed_Simon]

OK that wont work, you have to put the break tag after the loop has finished as
that is when the loop has finishaed and thus the whole record has been returned!

<cfoutput query="search">
<a
href="workDetail.cfm?projectID=#search.projectID#& catID=#search.catID#">#Project
Name#</a><br>
<cfloop list="#search.Description#..." index="ThisWord" delimiters=" ">
<cfif ListFindNoCase(FORM.Criteria, ThisWord, " ")>
<strong>#ThisWord#</strong>
<cfelse>
#ThisWord#
</cfif>
</cfloop><br />
</cfoutput>

[Kamesh192]

hi

super! thank for all your help

kamesh

[Kamesh192]

hi

super! thanks for all your help

kamesh