Re: adding a unique value to each record in an existing andlive

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43076
interpreted = N
texte = Thatıs exactly what you will need to do .. I had to do this to a db and ended up using a [tcpconnect] to get a new [cart] value over and over inside a [replacefounditems] ..Unfortunately there is no [newcart] in v4 ..Alain> 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/ ------------------------------------------------------------- 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: adding a unique value to each record in an existing andlive db (Michael Davis 2002)
  2. Re: adding a unique value to each record in an existing andlive db (Kenneth Grome 2002)
  3. Re: adding a unique value to each record in an existing andlive (Alain Russell 2002)
  4. Re: adding a unique value to each record in an existing andlive db (dale's stuff 2002)
  5. Re: adding a unique value to each record in an existing andlive (Alain Russell 2002)
Thatıs exactly what you will need to do .. I had to do this to a db and ended up using a [tcpconnect] to get a new [cart] value over and over inside a [replacefounditems] ..Unfortunately there is no [newcart] in v4 ..Alain> 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/ ------------------------------------------------------------- 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/ Alain Russell

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:

'RequiredField' Question (1998) WebCat2 - Getting to the browser's username/password data (1997) Fwd: Problems with Webcatalog Plug-in (1997) cc auth with [purchase] (1998) WC2b15 File Corruption (1997) Search (1997) # fields limited? (1997) set header in DB (no cart) (2003) WebCat2_Mac RETURNs in .db (1997) Banner Ad example (Typhoon) and WebCatalog (1997) RE: WebDNA-Talk searchable? (1997) Summing fields (1997) Add to a field (1998) (1998) Not really WebCat (1997) protect tag on NT IIS (1997) Serving .wml pages to WAP via webcat (2000) [WebDNA] [AddFields] Restrictions (2012) Bug when including a db file ... ? (2000) Assigning new CART number (1997)