Re: old problem
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39910
interpreted = N
texte = Thanks very much for replies Rob,If I were to type in http://myserver/thisprog.tplthis should do its business only it still leavesall the filenames in the db when they should bedeleted.Perhaps my dependencies are wrong. This should workassuming that a)orders/filelist.db has a .hdr with the wordfilenames in itb)does case matter with the word filenames in lineslike(i)[search db=orders/filelist.db&neFilenamesData=[blank]](ii)[delete db=orders/filelist.db&eqFILENAMESdata=[text]delFileThanks again. --- Rob Marquardt
wrote: > on11/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 Design> > 800 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/ __________________________________________________Do You Yahoo!?Everything you'll ever need on one web page from News and Sport to Email and Music Chartshttp://uk.my.yahoo.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)
|
Thanks very much for replies Rob,If I were to type in http://myserver/thisprog.tplthis should do its business only it still leavesall the filenames in the db when they should bedeleted.Perhaps my dependencies are wrong. This should workassuming that a)orders/filelist.db has a .hdr with the wordfilenames in itb)does case matter with the word filenames in lineslike(i)[search db=orders/filelist.db&neFilenamesData=[blank]](ii)[delete db=orders/filelist.db&eqFILENAMESdata=[text]delFileThanks again. --- Rob Marquardt wrote: > on11/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 Design> > 800 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/ __________________________________________________Do You Yahoo!?Everything you'll ever need on one web page from News and Sport to Email and Music Chartshttp://uk.my.yahoo.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/
Laeg Ent.
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:
Sorting error (1997)
Physical Security for WebCatalog Directories (1997)
PCS Frames (1997)
searching with if/then (2004)
[WebDNA] OS X mail server-Thanks (2009)
Grouping fields problem (1998)
WebCat2 - storing unformatted date data? (1997)
WebCatalog for guestbook ? (1997)
Using Cookie for client specific info? (1997)
UPS Shipping Docs (Where To Go) (1999)
[append] and SSL (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
[WebDNA] Finding duplicate email addresses (2008)
Quit revisited (1997)
update problem (1998)
Emailer (WebCat2) (1997)
Almost a there but..bye bye NetCloak (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
no global [username] or [password] displayed ... (1997)
[hideif] (1998)