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 filein /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]][deletedb=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 norank=on. Use rank=off to return results in the same order they appear in thedatabase.> [text]doDelete=[F][/text]If you're setting text variables to use as booleans, I'd recommend using Tand 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 thisequal 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 yourserver. If you don't have Commit Databases set to automatic in your WebCatpreferences, you might want to just put a [commitdatabasedb=orders/filelist.db] in there instead (outside the [founditems]) to commitjust that one database yet still leave it open in RAM. Do a [closedatabasedb=orders/filelist.db] if you want the database removed from RAM as well.Rob MarquardtDesigner/Resident WireheadToast Design800 Washington Avenue NorthMinneapolis MN 55401612.330.9863 v612.321.9424 fhttp://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 filein /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]][deletedb=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 norank=on. Use rank=off to return results in the same order they appear in thedatabase.> [text]doDelete=[F][/text]If you're setting text variables to use as booleans, I'd recommend using Tand 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 thisequal 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 yourserver. If you don't have Commit Databases set to automatic in your WebCatpreferences, you might want to just put a [commitdatabasedb=orders/filelist.db] in there instead (outside the [founditems]) to commitjust that one database yet still leave it open in RAM. Do a [closedatabasedb=orders/filelist.db] if you want the database removed from RAM as well.Rob MarquardtDesigner/Resident WireheadToast Design800 Washington Avenue NorthMinneapolis MN 55401612.330.9863 v612.321.9424 fhttp://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:
won't serve .tpl (2000)
Typhoon Rev. and PCS store problems (1999)
help with http upload again (2000)
text conversions (1999)
Apple event reply error (-1) (1997)
[WebDNA] Cicada - WebDNA_CICADA_6.1.b02 - gratz and request...! (2009)
WebCat2 Append problem (B14Macacgi) (1997)
The IBC root beer has arrived! (1997)
Show if time tags (1997)
Duplicates (1998)
can WC render sites out? (1997)
determining plug-ins? (1998)
AuthorizeNet Declines (2005)
Help with Repost Data msg from form (1997)
flushdatabases (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
WebCat2b13MacPlugIn - [include] (1997)
Cart problem (1999)
WebCatalog for Postcards ? (1997)
Comparing two fields so the match (1998)