Reindexing a db with duplicate numbers...
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25505
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... Thanks,Will Starck TigerNet Technologies, Inc.------------------------------------------------------------- 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... Thanks,Will Starck TigerNet Technologies, Inc.------------------------------------------------------------- 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
Will Starck
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:
Explorer 3.0 (1997)
Only charge card when product shipped ? (1997)
with Link i need to (1997)
[WebDNA] in principle, can we [setcookie] in a [spawn] ? (2009)
[ShowNext] (1997)
Limitations on fields? Server is crashing (1997)
Pre-flight public flag (1997)
What am I missing (1997)
writing orders to a db (1997)
Mime Headers for Mail (1998)
webcat NT (1998)
Error: the 'showcart' command requires that you specify a db (1997)
Rephrased: Web Site Stats (2002)
Golive parses [showif [index]<4] weird (2003)
[replaceChars] would be nice ... (1997)
[WriteFile] problems (1997)
[encrypt] blues.... (2000)
in header include files? (1998)
[OT] What System Software? (2003)
[WC 2.1.30] Stack overflow. (2000)