Re: [isfolder] and [filename]
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12095
interpreted = N
texte = >>What is the secret to removing an item from my db that is a duplicate. I>>have removed all info from the fields but I have 2 empty items with the>>same SKU. They will not delete.>>How are you trying to delete them? If you want to delete both records, this>should work fine:>>[delete db=xxx.db&eqskudata=puttheskuhere]>>I don't know why this wouldn't work for you, but if for any reason it>doesn't, you might have to go into the database and delete the duplicate>manually. Then rewrite your WebDNA so duplicates cannot be entered in the>first place, and you won't have to worry about duplicates anymore ... :)also keep in mind that the data is held in Ram and therefore if you systemcrashes before you close the databases either from the admin program or byusing the [closedatabase] tag you could have problems. You thought youreplaced or deleted the record and bingo it is still there. If I remembercorrectly Grant said that [append] writes to disk immediately but [replace]and delete] do not. Just for safety we use the [closedatabase] tag afterever [replace] or [delete].===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
Associated Messages, from the most recent to the oldest:
>>What is the secret to removing an item from my db that is a duplicate. I>>have removed all info from the fields but I have 2 empty items with the>>same SKU. They will not delete.>>How are you trying to delete them? If you want to delete both records, this>should work fine:>>[delete db=xxx.db&eqskudata=puttheskuhere]>>I don't know why this wouldn't work for you, but if for any reason it>doesn't, you might have to go into the database and delete the duplicate>manually. Then rewrite your WebDNA so duplicates cannot be entered in the>first place, and you won't have to worry about duplicates anymore ... :)also keep in mind that the data is held in Ram and therefore if you systemcrashes before you close the databases either from the admin program or byusing the
[closedatabase] tag you could have problems. You thought youreplaced or deleted the record and bingo it is still there. If I remembercorrectly Grant said that
[append] writes to disk immediately but
[replace]and delete] do not. Just for safety we use the
[closedatabase] tag afterever
[replace] or
[delete].===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
grichter@panavise.com (Gary Richter)
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:
Show if time tags (1997)
ThreadMem ignored? (1998)
Exclamation point (1997)
[SearchString] usage (1997)
Date or time comparisons have bugs ... (1998)
Is QuidProQuo dead? (1998)
WebCatalog can't find database (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Include a big block of text (1997)
RE: Tax and ShipCost Problem (1997)
Listserver problem (1997)
2.1b3 --> way slow (1997)
Re:Help name our technology! (1997)
[TaxableTotal] - not working with AOL and IE (1997)
Most Efficiant Way to do restricted Areas (1997)
MASTER_STORE revision (2002)
Sorting error (1997)
WebMerchant? (1998)
database visibility (2000)
Forms Search Questions (1997)