Click to See Complete Forum and Search --> : Two SQL Full-Index Search Questions


kwilliams
10-13-2003, 05:39 PM
Hello there,

QuickFacts: ASP, JavaScript, SQL Server 2k, Win2k (for dbo.Commission_Minutes)

I have two questions about some searchable pages that I've created for by DB table called dbo.Commission_Minutes. I received these questions from my boss, and I'm hoping to give him a quick estimate of how long it would take to complete these tasks. Here they are:

1) The user has 3 options on the search page (see http://www.douglas-county.com/Local_Govt/minutes.asp) to search for what's called "Minutes", including searching using keywords with a full-index search. I know how to display the beginning of the Minute using the "substring" method, but how can I display a Minute starting around where the keyword is, like Google's search? (see example under question #2)

2) How can I bold only the keyword in each Minute that's on the results page?

EXAMPLE:
Here's an example of what I'm talking about using "Minute" as keyword:

...here is the Minute. It contains information for the date of 12/30/2002. Not much happened in this meeting. Attendees included: Me...

Any and all help is appreciated. Thanks.