The only effective way to do this, would be to pull those records out of the database and make the change, then stick the data back in by updating the row.
-- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411<http://plus.google.com/108193156965451149543> On Tue, Aug 21, 2012 at 6:20 AM, Rich Smith <[email protected]> wrote: > > I am working on a project that will allow individual to add content to the > database. However, if the word "Thank you. I will see you later" is > mentioned in several tables, i would like to find a way to update all > fields with the new word OR statment ie "No Thank you. I will see you > later....etc". Basically, similar to what you would do in MS word to > change/replace a word to something else in a paragraph. Any help would be > greatly appreciated. Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5901 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
