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 system crashes before you close the databases either from the admin program or by using the [closedatabase] tag you could have problems. You thought you replaced or deleted the record and bingo it is still there. If I remember correctly Grant said that [append] writes to disk immediately but [replace] and delete] do not. Just for safety we use the [closedatabase] tag after ever [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 system crashes before you close the databases either from the admin program or by using the
[closedatabase] tag you could have problems. You thought you replaced or deleted the record and bingo it is still there. If I remember correctly Grant said that
[append] writes to disk immediately but
[replace] and delete] do not. Just for safety we use the
[closedatabase] tag after ever
[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:
Re:Emailer and encryption (1997)
Major Security Hole IIS NT (1998)
Emailer & IMail List Server (1998)
SQL Changes in 3.0.7? (2000)
WebDNA Solutions ... sorry! (1997)
TeaRoom Order fields email account remain empty even though thewy are filled. (1997)
Document Contains No Data! (1997)
newbies to web, spaces in email address (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Multiple adding (1997)
HideIf ip= OR ip= (1998)
[URL] and [showif] or [hideif] comparisons (2003)
BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (1999)
Windows-based Code Editor (2002)
Re:EMail not being sent (1999)
Add command creates new cart but I'm passing existing cart...? (2000)
Showif, Hideif reverse logic ? (1997)
Secure Server (1997)
'RequiredField' Question (1998)
Counting files (1998)