Re: Auto Delete EmailCompleted Files
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45655
interpreted = N
texte = I wouldn't call it a bug, more of a confusing yet not unexpected behavior if you think it through. Similar problems happen if you use [delete] inside a [founditems] to delete selected records from a database. If you mess with the control set for a loop, you can expect your loop to be messed with, regardless of the programming environment. Nevertheless, it has lead to many a confused programmer - you'd probably find dozens of topics related to this in the archives if you searched carefully.As for the date test, it worked fine for me - I have only the messages from the last 5 days in my completed folder (135 of the original 2000 or so).One possibility: when you look at the [moddate] from a fileinfo, are you getting a 2- or 4-digit year? It could be your system is set up to display 2-digit years, and therefore WebDNA thinks all the files were created in 1902, which is more than 60 days ago.I believe that on a Mac (classic), this date format comes from the Date & Time control panel -> date formats -> Show Century for short date. I don't know about other systems.- brianAt 4:55 PM -0600 11/22/02, Donovan wrote: >wierd, I confirmed this with my code. >could this be considered a bug? seems illogical to me. > >just to note, I tested brian's code with one modification. I have >completed emails dating back to august. I decided that >I would delete everything that is two months old or older. >I changed 5 to 60. the result was that all my completed >emails are gone (not a big deal as we have redundant >backups as well as they are not needed). > >Any ideas? > >at any rate, now I have a clean completed emails folder and >some new insight into the listfiles context. :-) > >cheers, >Donovan > > > >Brian Fries wrote:[snip] >The above script runs afoul of the dreaded delete while listing > >> conundrum, resulting in only every-other file being deleted. >> >> If you have 6 files, named a, b, c, d, e and f, then do a listfiles, >> deleting each time through, you will delete file a on the first >> pass, then file c on the second pass because c will now be the >> second file in the list because a no longer exists. The third pass >> will delete file e, leaving the three files b, d and f. >> >> My preferred way of dealing with this situation is to stick the names >> of all the files to be deleted into a text variable, then, after the >> [/listfiles], do a [listwords] on the file list to delete the listed >> files. >> >> Also, a more portable way of accessing the EmailCompleted folder is >> to go to the globals folder then back up a level. >> >> Here's my version - and I just tested it successfully on my server, >> as I'd been meaning to do this anyway: >> >> [text]deletelist=[/text] >> [text]completed=^../EmailCompleted/[/text] >> [text]fivedaysago=[math]{[date]}-5[/math][/text] >> [ListFiles path=[completed]] >> [hideif [math]{[ModDate]}[/math]>[fivedaysago]] >> [text]deletelist=[deletelist],[filename][/text] >> [/hideif] >> [/listfiles] >> [listwords words=[url][deletelist][/url]&delimiters=,] >> [DELETEFILE file=[completed][word]] >> [/listwords] >> >> - brian > > ---- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I wouldn't call it a bug, more of a confusing yet not unexpected behavior if you think it through. Similar problems happen if you use [delete] inside a [founditems] to delete selected records from a database. If you mess with the control set for a loop, you can expect your loop to be messed with, regardless of the programming environment. Nevertheless, it has lead to many a confused programmer - you'd probably find dozens of topics related to this in the archives if you searched carefully.As for the date test, it worked fine for me - I have only the messages from the last 5 days in my completed folder (135 of the original 2000 or so).One possibility: when you look at the [moddate] from a fileinfo, are you getting a 2- or 4-digit year? It could be your system is set up to display 2-digit years, and therefore WebDNA thinks all the files were created in 1902, which is more than 60 days ago.I believe that on a Mac (classic), this date format comes from the Date & Time control panel -> date formats -> Show Century for short date. I don't know about other systems.- brianAt 4:55 PM -0600 11/22/02, Donovan wrote: >wierd, I confirmed this with my code. >could this be considered a bug? seems illogical to me. > >just to note, I tested brian's code with one modification. I have >completed emails dating back to august. I decided that >I would delete everything that is two months old or older. >I changed 5 to 60. the result was that all my completed >emails are gone (not a big deal as we have redundant >backups as well as they are not needed). > >Any ideas? > >at any rate, now I have a clean completed emails folder and >some new insight into the listfiles context. :-) > >cheers, >Donovan > > > >Brian Fries wrote:[snip] >The above script runs afoul of the dreaded delete while listing > >> conundrum, resulting in only every-other file being deleted. >> >> If you have 6 files, named a, b, c, d, e and f, then do a listfiles, >> deleting each time through, you will delete file a on the first >> pass, then file c on the second pass because c will now be the >> second file in the list because a no longer exists. The third pass >> will delete file e, leaving the three files b, d and f. >> >> My preferred way of dealing with this situation is to stick the names >> of all the files to be deleted into a text variable, then, after the >> [/listfiles], do a [listwords] on the file list to delete the listed >> files. >> >> Also, a more portable way of accessing the EmailCompleted folder is >> to go to the globals folder then back up a level. >> >> Here's my version - and I just tested it successfully on my server, >> as I'd been meaning to do this anyway: >> >> [text]deletelist=[/text] >> [text]completed=^../EmailCompleted/[/text] >> [text]fivedaysago=[math]{[date]}-5[/math][/text] >> [ListFiles path=[completed]] >> [hideif [math]{[ModDate]}[/math]>[fivedaysago]] >> [text]deletelist=[deletelist],[filename][/text] >> [/hideif] >> [/listfiles] >> [listwords words=[url][deletelist][/url]&delimiters=,] >> [DELETEFILE file=[completed][word]] >> [/listwords] >> >> - brian > > ---- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Brian Fries
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:
Encrypt Decrypt URL UnURL Weirdness (2001)
Nesting Search Within ![]()
Tag? (1997)
RE: shrink-wrapped version out yet? (1997)
Supressing Error Messages (1998)
webcat 4.5 (2003)
Getting total number of items ordered (1997)
HomePage Caution (1997)
WebCommerce: Folder organization ? (1997)
Sorry I didn't pay attention-but ??? (1997)
Server Takes 2 Hours to Boot UP (2004)
Multiple prices (1997)
[authenticate] (1999)
Odd request (2003)
The [shownext] limitations (2002)
Generating Report Totals (1997)
Three new problems, maybe a fourth (1997)
Emailer update for Mac? (1998)
Introduction/Tutorial/QuickStart (1997)
Protect and Serve (1999)
[switch][case] (2004)