automatically updating all records, one by one in a db

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 36229
interpreted = N
texte = Hello,I have to update some information in each record of a live production database. There are a couple of different fields that need to be updated and I want to make sure I do things correctly as to not mess up my db.I am looking for the best way to crawl through the database to perform these updates.One update needed to be done is to change the date format from US type to formatted as a number. I do have an additional field in the database for this new information.Next is updating the path the an image which is associated with each individual record. This update involves moving the image and updating the record. I already so this when individual records are updated, I am trying to find the safest way to update all records ind of at once.So how do I do a search, with results for only 1 at a time, make the changes, then proceed to the next record that needs to be updated?Thanks ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: automatically updating all records, one by one in a db (Dale 2000)
  2. Re: automatically updating all records, one by one in a db (Dale 2000)
  3. Re: automatically updating all records, one by one in a db (Peter Ostry 2000)
  4. Re: automatically updating all records, one by one in a db (WebDNA Support 2000)
  5. Re: automatically updating all records, one by one in a db (Peter Ostry 2000)
  6. automatically updating all records, one by one in a db (Dale 2000)
Hello,I have to update some information in each record of a live production database. There are a couple of different fields that need to be updated and I want to make sure I do things correctly as to not mess up my db.I am looking for the best way to crawl through the database to perform these updates.One update needed to be done is to change the date format from US type to formatted as a number. I do have an additional field in the database for this new information.Next is updating the path the an image which is associated with each individual record. This update involves moving the image and updating the record. I already so this when individual records are updated, I am trying to find the safest way to update all records ind of at once.So how do I do a search, with results for only 1 at a time, make the changes, then proceed to the next record that needs to be updated?Thanks ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Dale

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[/application] error? (1997) Setting up shop (1997) FlushDatabase Suggestion (1998) Press Release hit the NewsWire!!! (1997) Hosting Service (1998) [ShowNext] (1997) WebMerchant Only reads 1.4 order files error (1997) [OT] Display Glitch (2004) Opinion: [input] should be called [output] ... (1997) emailer w/F2 (1997) WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997) Secured Order Forms (1998) Adding content advice needed (1998) LOG IN LOG OUT (1997) webdna+post+WinIE6 (2004) Re:WebCatalog f2 Installation (1997) Limit to Field Length in DB (1998) Uh...can someone help me out with the b10? (1997) Re1000001: Setting up shop (1997) RE: OK, here goes... (1997)