Re: old problem

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39880
interpreted = N
texte = on 11/5/01 6:43 am, Laeg Ent. at laeg_enterprises@yahoo.co.uk so noted...> I still have the same problem. I am trying to compare > the list of filenames in a folder A with a list of > filenames in a db file B. If an an order name appears > in B that is not in A then we delete that filename out > of the db file. Seems like a well confined problem but > I'm having trouble with it. I think its my placement > of [Flushdatabases], but I'm not sure.Sorry, the solution I posted a week ago did the opposite of what you were looking for (it removed matching items from the db, leaving the unmatched). This one does the compare and removal properly. [math show=f]delTotal=0[/math][search db=orders/filelist.db&neFilenamesData=[blank]] [founditems] [text]delFile=T[/text] [listfiles path=orders] [showif [filename]=[filenames]] [text]delFile=F[/text] [/showif] [/listfiles] [showif [delFile]=T] [math show=F]delTotal=[delTotal]+1[/math] [text]delFile[delTotal]=[filenames][/text] [/showif] [/founditems] [/search][loop start=1&end=[delTotal]] [delete db=orders/filelist.db&eqFILENAMESdata=[text]delFile[index][/text]] [/loop] The other comments from the 31st are still valid:> [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: [WebDNA] Old Problem, the exclamation point (Terry Wilson 2014)
  2. Re: [WebDNA] Old Problem, the exclamation point (Terry Wilson 2014)
  3. Re: [WebDNA] Old Problem, the exclamation point (Donovan Brooke 2014)
  4. Re: [WebDNA] Old Problem, the exclamation point (Terry Wilson 2014)
  5. Re: [WebDNA] Old Problem, the exclamation point (Steve Braun 2014)
  6. Re: [WebDNA] Old Problem, the exclamation point (Terry Wilson 2014)
  7. Re: [WebDNA] Old Problem, the exclamation point (Donovan Brooke 2014)
  8. Re: [WebDNA] Old Problem, the exclamation point (Steve Braun 2014)
  9. Re: [WebDNA] Old Problem, the exclamation point (Tom Duke 2014)
  10. [WebDNA] Old Problem, the exclamation point (Steve Braun 2014)
  11. Re: old problem (Brian Fries 2001)
  12. Re: old problem (Rob Marquardt 2001)
  13. Re: old problem (Laeg Ent. 2001)
  14. Re: old problem (Laeg Ent. 2001)
  15. Re: old problem (Rob Marquardt 2001)
  16. Re: old problem (Laeg Ent. 2001)
  17. Re: old problem (Rob Marquardt 2001)
  18. old problem (Laeg Ent. 2001)
  19. Re: OLD PROBLEM (bob 1997)
  20. OLD PROBLEM (natasha 1997)
on 11/5/01 6:43 am, Laeg Ent. at laeg_enterprises@yahoo.co.uk so noted...> I still have the same problem. I am trying to compare > the list of filenames in a folder A with a list of > filenames in a db file B. If an an order name appears > in B that is not in A then we delete that filename out > of the db file. Seems like a well confined problem but > I'm having trouble with it. I think its my placement > of [flushdatabases], but I'm not sure.Sorry, the solution I posted a week ago did the opposite of what you were looking for (it removed matching items from the db, leaving the unmatched). This one does the compare and removal properly. [math show=f]delTotal=0[/math][search db=orders/filelist.db&neFilenamesData=[blank]] [founditems] [text]delFile=T[/text] [listfiles path=orders] [showif [filename]=[filenames]] [text]delFile=F[/text] [/showif] [/listfiles] [showif [delFile]=T] [math show=F]delTotal=[delTotal]+1[/math] [text]delFile[delTotal]=[filenames][/text] [/showif] [/founditems] [/search][loop start=1&end=[delTotal]] [delete db=orders/filelist.db&eqFILENAMESdata=[text]delFile[index][/text]] [/loop] The other comments from the 31st are still valid:> [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:

[WebDNA] Sorry WebDNA server not running (2014) [WebDNA] Webdna and CMS (2012) [WebDNA] MACWORLD 09 SanFran (2009) service stop and restart (1997) searching multiple databases (1997) [OT] ODBC between IIS and remote Access problem (2000) Was code to phantom spacing -- now BBEdit [!][/!] (2001) WebCommerce: Folder organization ? (1997) [/application] error? (1997) Creditcard verification with WebCat (1998) Trouble with formula.db (1997) Re:no [search] with NT (1997) &max= (2003) Cookies and webcat (1997) Announcing general availabilty of WebDNA 4.5 release (2002) Help! WebCat2 bug (1997) problems with 2 tags (1997) Question about replacing words (1998) [sendmail] questions... (1997) WebCat2 - [format thousands] (1997)