Chad, I had to do this very same thing for cfindex. There is another alternative - look for a stored procedure code for your database server that strips HTML. If you can find one, you can transform it in the database before you get it.
Dave -----Original Message----- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Wednesday, October 07, 2009 3:39 PM To: cf-talk Subject: RE: modifying a query object Query of queries offer no string manipulation. Therefore I would recommend a cfloop over the result set and a regular expression applied to each record. ~Brad -------- Original Message -------- Subject: modifying a query object From: "Chad Gray" <cg...@careyweb.com> Date: Wed, October 07, 2009 3:06 pm To: cf-talk <cf-talk@houseoffusion.com> So I am doing a query on a database and passing the query object to CFIndex to refresh a Verity collection. I need to remove some characters (HTML tags in the query result) from the query object before passing it to CFIndex. What is the best way to find/replace the HTML tags in the query object before passing the query to CFIndex? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327007 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4