Re: user flush db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46042
interpreted = N
texte = Now, just in case your users do not have all their .db files in one directory and you quickly want to flush an entire virtual host ..This might help: Copy the code below into a file in the root of the virtual host, the file will create an include file, loop through the directories in the virtual host and close the databases (.db files), then deletes the include file it wrote (to keep everything clean).Alain ----------------------[!] ## Write the loop file which explores the folders --[/!] [writefile file=flush_db_loop.inc] [raw] [listfiles path=[fullpath]] [showif [filename]^.db] Closing: [fullpath]
[closedatabase db=[fullpath]] [/showif] [showif [isfolder]=T] [include file=flush_db_loop.inc] [/showif] [/listfiles] [/raw] [/writefile][!] ## Loop through the directories and flush the databases --[/!] [listfiles path=/] [showif [filename]^.db] Closing: [fullpath]
[closedatabase db=[fullpath]] [/showif] [showif [isfolder]=T] [include file=flush_db_loop.inc] [/showif] [/listfiles][!] ## Delete the loop file we created at the start --[/!] [deletefile file=flush_db_loop.inc] ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: user flush db (Kalin Mintchev 2002)
  2. Re: user flush db (Stuart Tremain 2002)
  3. Re: user flush db (Alain Russell 2002)
  4. Re: user flush db (Kalin Mintchev 2002)
  5. Re: user flush db (Gary Krockover 2002)
  6. Re: user flush db (Kalin Mintchev 2002)
  7. Re: user flush db (Alain Russell 2002)
  8. Re: user flush db (Donovan Brooke 2002)
  9. Re: user flush db (Alain Russell 2002)
  10. Re: user flush db (Michael Quattrone 2002)
  11. Re: user flush db (Donovan Brooke 2002)
  12. Re: user flush db (Gary Krockover 2002)
  13. Re: user flush db (Gary Krockover 2002)
  14. Re: user flush db (Alain Russell 2002)
  15. Re: user flush db (Donovan Brooke 2002)
  16. Re: user flush db (Alain Russell 2002)
  17. user flush db (Kalin Mintchev 2002)
Now, just in case your users do not have all their .db files in one directory and you quickly want to flush an entire virtual host ..This might help: Copy the code below into a file in the root of the virtual host, the file will create an include file, loop through the directories in the virtual host and close the databases (.db files), then deletes the include file it wrote (to keep everything clean).Alain ----------------------[!] ## Write the loop file which explores the folders --[/!] [writefile file=flush_db_loop.inc] [raw] [listfiles path=[fullpath]] [showif [filename]^.db] Closing: [fullpath]
[closedatabase db=[fullpath]] [/showif] [showif [isfolder]=T] [include file=flush_db_loop.inc] [/showif] [/listfiles] [/raw] [/writefile][!] ## Loop through the directories and flush the databases --[/!] [listfiles path=/] [showif [filename]^.db] Closing: [fullpath]
[closedatabase db=[fullpath]] [/showif] [showif [isfolder]=T] [include file=flush_db_loop.inc] [/showif] [/listfiles][!] ## Delete the loop file we created at the start --[/!] [deletefile file=flush_db_loop.inc] ------------------------------------------------------------- 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://webdna.smithmicro.com/ Alain Russell

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:

WebCat2b12 Mac.acgi--[searchstring] bug (1997) How To question on setting up downloads (1997) Unexpected error (1997) Trouble with formula.db (1997) range searching (1998) One more time (1997) Extended [Concvertchars] needed (1997) math a various prices (1997) WebCat2: Items xx to xx shown, etc. (1997) Which GUI HTML editors work with WC ? (1997) mass mailing (1998) Replace Statement (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) expired beta (1997) SQL Support (2000) Week # problem (1998) shortening the cart (1998) Need help... (1997) [OT] What log analyzer do you use? (2000) Nested tags count question (1997)