What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

    
  1. Re: Any help gratefully appreciated (Rob Marquardt 2001)
  2. Re: Any help gratefully appreciated (Laeg Ent. 2001)
  3. Re: Any help gratefully appreciated (Rob Marquardt 2001)
  4. Re: Any help gratefully appreciated (dale 2001)
  5. Re: Any help gratefully appreciated (Laeg Ent. 2001)
  6. Re: Any help gratefully appreciated (Laeg Ent. 2001)
  7. Re: Any help gratefully appreciated (dale 2001)
  8. Any help gratefully appreciated (Laeg Ent. 2001)
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:

Clickable maps and WebCatalog? (1996) RE: [WebDNA] WebDNA & VPS (2009) Execute Applescript (1997) [FoundItems] Image Gallery (2001) Javascript and Pull Down menus (1999) SiteEdit NewFile.html ? (1997) removing programming logic white space (2003) problems with 2 tags (1997) [WebDNA] plupload ? (2012) Webcatalog 4.0 - When will we be able to beta test it? (2000) [WebDNA] WebDNA & MySQL (2014) This list needs a digest: rant, rave... (1997) Blocking form spam (2006) BUG NOTICE: (2003) Separate SSL Server (1997) X etc.... (1999) $Quit, $CloseDatabase corrections (1997) executive server side java within webDNA (1997) WebObjects (1998) No Access warning when caching HTML files (1997)