Good point Dave. I had jumped to the conclusion that the OP had no control over the SQL being run on the database.
I'm not going to promise the database will be any faster depending on how complex of a replacement you need, but doing it prior to the app server is a definite option. ~Brad -------- Original Message -------- Subject: RE: modifying a query object From: Dave Phillips <[email protected]> Date: Wed, October 07, 2009 3:47 pm To: cf-talk <[email protected]> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
