In our case, we couldn't do it in the DB (Oracle) because we were dealing
with CLOB's and they were just too big.
Once we had it in a CF query, however, looping over the results wasn't a big
deal because this was working in a nightly batch job anyway.
Hey anyone, does CF 9 allow this:
<cfquery dbtype="query">
UPDATE myQuery
SET myString = replace(myString,"no","NO","all")
</cfquery>
Now THAT would be nice... ;-)
Dave
-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Wednesday, October 07, 2009 3:59 PM
To: cf-talk
Subject: RE: modifying a query object
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:327010
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
