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 werelooking 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 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:
|
- Re: [WebDNA] Old Problem, the exclamation point (Terry Wilson 2014)
- Re: [WebDNA] Old Problem, the exclamation point (Terry Wilson 2014)
- Re: [WebDNA] Old Problem, the exclamation point (Donovan Brooke 2014)
- Re: [WebDNA] Old Problem, the exclamation point (Terry Wilson 2014)
- Re: [WebDNA] Old Problem, the exclamation point (Steve Braun 2014)
- Re: [WebDNA] Old Problem, the exclamation point (Terry Wilson 2014)
- Re: [WebDNA] Old Problem, the exclamation point (Donovan Brooke 2014)
- Re: [WebDNA] Old Problem, the exclamation point (Steve Braun 2014)
- Re: [WebDNA] Old Problem, the exclamation point (Tom Duke 2014)
- [WebDNA] Old Problem, the exclamation point (Steve Braun 2014)
- Re: old problem (Brian Fries 2001)
- Re: old problem (Rob Marquardt 2001)
- Re: old problem (Laeg Ent. 2001)
- Re: old problem (Laeg Ent. 2001)
- Re: old problem (Rob Marquardt 2001)
- Re: old problem (Laeg Ent. 2001)
- Re: old problem (Rob Marquardt 2001)
- old problem (Laeg Ent. 2001)
- Re: OLD PROBLEM (bob 1997)
- 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 werelooking 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 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:
[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)