Re: Reindexing a db with duplicate numbers...
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25509
interpreted = N
texte = >Here's the situation: > >I [append] all my orders to an orders.db. Each order is supposed to have a >unique ordernumber, which is appended to orders.db as field ordernum. > >Due to a bug in one of my templates, some of these orders now have duplicate >ordernumbers. I thought I'd correct this with something like the following >code in a template: > > >[search db=orders.db&neordernumdata=[blank]&asmoddatesort=1&asmodtimesort=2] >[founditems] >[replace db=orders.db&eqordernumdata=[ordernum]]ordernum=[index][/replace] >[/founditems] >[/search] > > >Of course, that doesn't work. Anyone have a suggestion as to what search >criteria I can put in the [replace] to make this work? All I want to do is >sequentially renumber all the records in this db...Import it into Panorama, click the 'ordernum' field, choose 'Sequence' from the 'Math' menu, enter 1 1 which will create a sequence starting at one and incrementing by one, click the OK button, then export the results as a tab delimited text file and you're done.================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
>Here's the situation: > >I [append] all my orders to an orders.db. Each order is supposed to have a >unique ordernumber, which is appended to orders.db as field ordernum. > >Due to a bug in one of my templates, some of these orders now have duplicate >ordernumbers. I thought I'd correct this with something like the following >code in a template: > > >[search db=orders.db&neordernumdata=[blank]&asmoddatesort=1&asmodtimesort=2] >[founditems] >[replace db=orders.db&eqordernumdata=[ordernum]]ordernum=[index][/replace] >[/founditems] >[/search] > > >Of course, that doesn't work. Anyone have a suggestion as to what search >criteria I can put in the [replace] to make this work? All I want to do is >sequentially renumber all the records in this db...Import it into Panorama, click the 'ordernum' field, choose 'Sequence' from the 'Math' menu, enter 1 1 which will create a sequence starting at one and incrementing by one, click the OK button, then export the results as a tab delimited text file and you're done.================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
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:
How to get shownext to just shownext once (1997)
P3P and IE 6 (2004)
[WebDNA] [MATH] & formatting (2015)
Configuring E-mail (1997)
PIXO with cometsite ... and/or other plugins (1998)
Multiple catalog databases and showcart (1997)
Summing results of a nested search (2006)
[WebDNA] Display Live URL from a Block of Copy (2009)
[WebDNA] png support in webDNA (2011)
Credit Card Number checking (1997)
OT: Validating user input (2004)
READFILE command? (1998)
includes and cart numbers (1997)
Emailer 1.01 bombs (1997)
Why won't this work (2005)
Re:PCS Customer submissions ? (1997)
Country & Ship-to address & other fields ? (1997)
Webmerchant quitting (1998)
[WebDNA] [tcpconnect] timeout (2015)
Access Denied! But why? (1997)