The show_text is the "filtered" result. The highlight is incidental.
Just replace delim1 and delim 2 with "" if you dont want to highlight the
results.
If your concern is the amount of data returned you could write a udf in sql
server which would
build the "filtered" results in a table before they were returned. SQL
Server has all string manipulation functions you need
to do the equivalent filtering I did in cf.
If you are interested in this contact me off list.
Don Vawter
www.cyberroomies.com
[EMAIL PROTECTED]
----- Original Message -----
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, September 03, 2001 10:31 AM
Subject: RE: SQL Filtered SELECT
> Don,
>
> > If there is any interest I could write either a custom tag or
> > udf to do this.
>
> The idea was the filter the SELECT, and not highlight the search
> term(s).
> Is there a way to minimze the amount of data sent by CFQUERY like I
> need?
>
> 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
