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:

Multiple Choices in One Entry - Clothing Sizes (2000) Add htmlarea 3 to SiteBuilder (2004) [OT] will work for... (2003) PIXO support (1997) Part 2 - [showif] if variable exists (1998) and passing to a cart (1997) Another pair of eyes?? (2006) Displaying photo attached to first record (1997) Ship via options price (2000) removelineitems (2000) [BULK] [WebDNA] How to code a 301 redirect (2009) WebCat2 - [format thousands] (1997) Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997) replacing items in a db (2000) OT: well sort of - database design (2003) Newbie problem blah blah blah (1997) re:Clickable maps and WebCatalog? (1996) Superfilous Characters (1998) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Looking up two prices in database? (1997)