One suggestion I can make though, if you do decide to use loops. You
don't have to loop over the entire description of each result.
The cfexit tag comes in really handy in these cases. As in <cfexit
method="loop">
<cfset thecounter = 1>
<cfloop list="#qry.Description#" index="i" delimiters=" ">
<cfif thecounter LT 100>
<cfset newlist = newlist & " " & listgetat(list,i," ")>
<cfelse>
<cfexit method="LOOP">
</cfif>
<cfset thecounter = thecounter + 1>
</cfloop>
_____________________________
steve oliver
senior internet developer
atnet solutions, inc.
http://www.atnetsolutions.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 4:58 PM
To: CF-Talk
Subject: Re: Experts Only! - Summarizing Results
Steve,
> What I did though was treat the description as a list, delimited by
> spaces and chr(13)'s.
and? I don't think it would be wise to loop the entire list of 4K text
for 20 results per page.
> _____________________________
> steve oliver
> senior internet developer
> atnet solutions, inc.
> http://www.atnetsolutions.com
>
>
> -----Original Message-----
> Wrom: VTLBXFGGMEPYOQKEDOTWFAOBUZXUWLSZLKBRNVWWCUFPE
> Sent: Sunday, February 24, 2002 4:24 PM
> To: CF-Talk
> Subject: Experts Only! - Summarizing Results
>
>
> I'm running a full text search on my Product table using MSSearch
> service.
>
> Query looks something like this:
>
> SELECT Product_title,Product_description
> FROM Products
> WHERE CONTAINS (*,'"#Query_filtered#"')
>
> Where Query_filtered is something similiar to "deskjet|printer|hp"
>
> Anyhow, in the end I'm recivng the entire Product_description (about
4K
> varchar)
> to output in <CFOUTPUT>, for every result - problem is - I want to
> display a
> summarize result (like google does) and NOT something simple as,
> a mid, with 100 characters to the left/right.
>
> I've thought of a mechanisem, but can't seem to code it - idea is to
> find the positions of each word start/end, increase those "markers" by
> |10|
> range (both sides) and assemble a 2-3 sentences, connected via "..."
>
> for example: 50-55, 60-63, 91-95
> would be: 40-65, 50-73, 81-105 and then:
> I can make a "long" sentence out of 40-73 (2 words are in the same
> range),
> then I add "..." and glue a sentence from 81 to 105.
>
> I will need to treat spaces in the end, also (not to cut into a word,
> just on
> spaces.. but that's another process..) - any help will be appriciated!
>
> Experts only? I think...
>
>
>
>
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
