try this:
searchList = replace(searchString," ",",","all");
highlightList = "<b>#replace(searchString," ","</b>,<b>","all")#</b>";
SELECT left(whateverColumn,20) AS shortDescription
FROM whateverTable
<cfoutput query="whatever">
#replaceList(shortDescription,searchList,highlightList)#<br>
</cfoutput>
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 1:54 PM
To: CF-Talk
Subject: Me Vs. Search Results
I'm trying to output a google like results from SQL (not verity):
1. Build a summarize result that contains only sentences that includes
most of the search word/pharases.
2. Highlight the summary - so that any search term(s) from the query
will be bold. (in example i've marked bold/highligheted as |word|):
This should apply to single/multiple search term(s):
for example, a search for "hp printer buy" would give:
|Printer|s are a wonderful thing ...|HP| announce the new laser |printer|
...
and a network |print| server come standard with the |HP| LaserJet 2200dn,
and it's a good
bargain for |buy|ers... has our vote, hands down, as the best |printer|
|buy| of the year. ...
Any help would be great!
Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
