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" <[email protected]> Date: Wed, October 07, 2009 3:06 pm To: cf-talk <[email protected]> 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:327006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
