Re: Any help gratefully appreciated
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39798
interpreted = N
texte = on 10/31/01 9:56 am, Laeg Ent. at laeg_enterprises@yahoo.co.uk so noted...> --- dale
wrote: > It is not > safe to delete files within a listfiles. >> >> When you use listfiles it counts all the files, so >> if you have 10 files, >> then delete one, listfiles still thinks you have 10, >> which is why they do >> not delete as you think they should. > > Is it not ok in this case as the deleting is done > outside of the listfiles????The problem is that you're deleting records from your database within your [founditems] loop. You'd have to move the deletion outside.This should remove any entry in filelist.db that *doesn't* appear as a file in /orders:[math show=f]delTotal=0[/math][listfiles path=orders] [showif [lookup db=orders/filelist.db&value=[filename]&lookInField=[filenames]&returnField=[ filenames]¬Found=]=] [math show=f]delTotal=[delTotal]+1[/math] [text]delFile[delTotal]=[filename][/text] [/showif] [/listfiles][loop start=1&end=[delTotal]] [delete db=orders/filelist.db&eqFILENAMESdata=[text]delFile[index][/text]] [/loop] A couple side notes:> [search > db=orders/filelist.db&neFILENAMESdatarq=find_all&rank=on]Parameters within WebCat commands shouldn't be quoted. Also, there's no rank=on. Use rank=off to return results in the same order they appear in the database.> [text]doDelete=[F][/text]If you're setting text variables to use as booleans, I'd recommend using T and F instead of [T] and [F].> [If [filenames]=[filename]] > [then] > [text]doDelete=[T][/text] > [/then] > [else] > [/else] > [/If]If you're not needing it, the [else] is optional. And for simple does this equal this comparisons, [showif] is your friend! : )> [delete > db=orders/filelist.db&eqFILENAMESdatarq=[filenames]] > [FlushDatabases] > [/founditems][FlushDatabases] is going to commit and close *all* databases open on your server. If you don't have Commit Databases set to automatic in your WebCat preferences, you might want to just put a [commitdatabase db=orders/filelist.db] in there instead (outside the [founditems]) to commit just that one database yet still leave it open in RAM. Do a [closedatabase db=orders/filelist.db] if you want the database removed from RAM as well. Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f http://www.toastdesign.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
on 10/31/01 9:56 am, Laeg Ent. at laeg_enterprises@yahoo.co.uk so noted...> --- dale wrote: > It is not > safe to delete files within a listfiles. >> >> When you use listfiles it counts all the files, so >> if you have 10 files, >> then delete one, listfiles still thinks you have 10, >> which is why they do >> not delete as you think they should. > > Is it not ok in this case as the deleting is done > outside of the listfiles????The problem is that you're deleting records from your database within your [founditems] loop. You'd have to move the deletion outside.This should remove any entry in filelist.db that *doesn't* appear as a file in /orders:[math show=f]delTotal=0[/math][listfiles path=orders] [showif [lookup db=orders/filelist.db&value=[filename]&lookInField=[filenames]&returnField=[ filenames]¬Found=]=] [math show=f]delTotal=[delTotal]+1[/math] [text]delFile[delTotal]=[filename][/text] [/showif] [/listfiles][loop start=1&end=[delTotal]] [delete db=orders/filelist.db&eqFILENAMESdata=[text]delFile[index][/text]] [/loop] A couple side notes:> [search > db=orders/filelist.db&neFILENAMESdatarq=find_all&rank=on]Parameters within WebCat commands shouldn't be quoted. Also, there's no rank=on. Use rank=off to return results in the same order they appear in the database.> [text]doDelete=[F][/text]If you're setting text variables to use as booleans, I'd recommend using T and F instead of [T] and [F].> [If [filenames]=[filename]] > [then] > [text]doDelete=[T][/text] > [/then] > [else] > [/else] > [/If]If you're not needing it, the [else] is optional. And for simple does this equal this comparisons, [showif] is your friend! : )> [delete > db=orders/filelist.db&eqFILENAMESdatarq=[filenames]] > [flushdatabases] > [/founditems][flushdatabases] is going to commit and close *all* databases open on your server. If you don't have Commit Databases set to automatic in your WebCat preferences, you might want to just put a [commitdatabase db=orders/filelist.db] in there instead (outside the [founditems]) to commit just that one database yet still leave it open in RAM. Do a [closedatabase db=orders/filelist.db] if you want the database removed from RAM as well. Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f http://www.toastdesign.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://search.smithmicro.com/
Rob Marquardt
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:
when is date system date or order date? (1997)
WebCatalog.acgi quitting with error Type 2 (1998)
[SearchString] problem with [search] context (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Dealer locator (1998)
Mozilla/4. and Browser Info.txt (1997)
Is this possible in simple search? question? (1998)
Any way to retrieve information from clipboard? (1998)
Date Comparison (1998)
Include a big block of text (1997)
carriage returns in data (1997)
WebMerchant Only reads 1.4 order files error (1997)
available times? (2003)
Who needs Yoda! (2002)
Grant, please help me ... (1997)
Execute Applescript (1997)
Cart Database (1999)
RE: [isfolder] and [filename] (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Need help... (1997)