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 Consultant808-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 Consultant808-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:
Generating and appending SKU to a db automatically (1998)
SKU lookup (1997)
searchable list archive (1997)
[OT] Theiving B*****ds (2004)
Summary search -- speed (1997)
Looking up two prices in Formulas.db (1997)
No Wanna Duppys (1998)
Redirect frame targets (1998)
restart needed???? (1997)
[WebDNA] Trigger troubles (2014)
Authenticate v6 (2004)
New WebCatalog site! (1997)
4.5.1 Upgrade... (2003)
Multiple security dbs (1997)
Thanks ! (1997)
WC2.0 Memory Requirements (1997)
WebCat2 - [format thousands] (1997)
WebCat2.0 [format thousands .0f] no go (1997)
Fun with dates (1997)
FEA REQ: One .hdr, multiple .db's (2003)