And, unless you have some magic way to get the left 200 elements of a list, the only other option I can think of is a CFX. CF is pretty slow when it comes to major string manipulations.
_____________________________ 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... > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
