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:
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Press Release hit the NewsWire!!! (1997)
Generating Report Totals (1997)
Re[2]: Using [Include] Context (1999)
permission deny help please (2004)
Re:no [search] with NT (1997)
problems with 2 tags (1997)
firewall ports for Mac OS X/WebCatalog (2001)
Command=Showcart? (2000)
Converting characters to numbers ... (1997)
set header in DB (no cart) (2003)
referrer variable (1997)
Multiple prices (1997)
Quantity discount on some items? (2000)
More on the email templates (1997)
Error:Too many nested [xxx] contexts (1997)
Replace Statement (1997)
[WebDNA] Help with work-around format date (2013)
chat opinion ... (2002)
Version 4? (2000)