adding a unique value to each record in an existing and live db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43074
interpreted = N
texte = Hi,I have a database that I need to add anew ID field to. Actually the header has already been changed and I have started using [cart] on saving ot updating these records to achieve this. However, that still leaves over 10, 000 records without any content in this new field.Am I basically stuck with creating a template that does a search for any record with that field as blank and then updating it - one by one?Thanks for any suggestions.Oh, and yes, this is a live database so I can't take it offline and use some other process. I would like to use [cart] to get that unique number.Webcat 4.0.2 on Linux.Dale ------------------------------------------------------------- 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. adding a unique value to each record in an existing and live db (dale's stuff 2002)
Hi,I have a database that I need to add anew ID field to. Actually the header has already been changed and I have started using [cart] on saving ot updating these records to achieve this. However, that still leaves over 10, 000 records without any content in this new field.Am I basically stuck with creating a template that does a search for any record with that field as blank and then updating it - one by one?Thanks for any suggestions.Oh, and yes, this is a live database so I can't take it offline and use some other process. I would like to use [cart] to get that unique number.Webcat 4.0.2 on Linux.Dale ------------------------------------------------------------- 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's stuff

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:

Share Snippet? (1999) Trouble with my database (1998) Who owns the code? (2002) b12 cannot limit records returned and more. (1997) NT or Mac (1997) Using WebMerchant Only? (1998) POST (1997) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) WebCat2b15MacPlugin - showing [math] (1997) PCS Customer submissions ? (1997) 2.0 Info (1997) Bug alert! (1997) Multiple Newcarts (1996) Re:Non-technical messages ... (1997) cart file creation (2003) Help! WebCat2 bug (Ben's input) (1997) [WebDNA] Anyone use this coding style for readability... (2010) emailer (1997) WebCat2: Items xx to xx shown, etc. (1997) F2 to F3 rocky transition (1997)