House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home /  Groups /  ColdFusion Newbie (CF-Newbie)

Updating a particular word in several tables

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Rich Smith
08/20/2012 04:20 PM

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.

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Andrew Scott
08/20/2012 05:55 PM

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>; ----- Excess quoted text cut - see Original Post for more -----


<< Previous Thread Today's Threads Next Thread >>

Search cf-newbie

May 25, 2013

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31   

Designer, Developer and mobile workflow conference