Re: adding a unique value to each record in an existing andlive db
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43092
interpreted = N
texte = >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?No, but that's probably the easiest way to do it. I would just create a template with a meta refresh tag in it, and make it refresh every second, then let it run overnight or until you think it's run long enough to replace all the blanks with [cart] values. Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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:
>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?No, but that's probably the easiest way to do it. I would just create a template with a meta refresh tag in it, and make it refresh every second, then let it run overnight or until you think it's run long enough to replace all the blanks with [cart] values. Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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/
Kenneth Grome
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:
[WebDNA] why is this cookie being set to expire at end of browser session? (2009)
Am I going senile? (Price recalc based on quantity) (1997)
Subtotal Not Calculated on Invoice.html (1998)
webcat 2.1 new cart fields - please explain more (1998)
How can I record purchases to a database? (1998)
Serving images from databases (1998)
[WebDNA] WebDNA and MAMP/Apache (Mac) (2018)
form crasehes server (1997)
New Guestbook Source (1997)
append db wierdness (1999)
PCS Frames (1997)
Sort Floating Point Number (2008)
WebCat2: Items xx to xx shown, etc. (1997)
Dark Horse Comics success story (1997)
Netscape v. IE (1997)
sendmail spaces (1997)
Adding a donation amount (2000)
Triggers (2003)
[dos] command question (1997)
SiteEdit Pro Update Announcement (1997)