Re: user flush db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46044
interpreted = N
texte = ok. it's in only one directory, but thanks - i'll keep this in my archives.... On Thursday, December 5, 2002, at 11:20 PM, Alain Russell wrote:> 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/ > ------------------------------------------------------------- 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)
ok. it's in only one directory, but thanks - i'll keep this in my archives.... On Thursday, December 5, 2002, at 11:20 PM, Alain Russell wrote:> 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/ > ------------------------------------------------------------- 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/ Kalin Mintchev

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:

Max Record length restated as maybe bug (1997) WebCatalog 4.0.2b5 available (2000) Webcatalog 4.02b5 Mac OS X headers (2000) Cart doesn't interpret tag! (1997) Req: Row DB feature (2004) [WebDNA] SQLExecute Memory Leak (2008) [delete] problem (1997) webdna code shows on .htm extensions. (2000) Re:Dashes and dots in credit card (1998) [math] and ceil (2004) Getting total number of items ordered (1997) Authenticate (1997) XML version of WebDNA docs? (2000) Duplicate Items in the Cart (1998) [WebDNA] Scheduling App (2017) WebSTAR 2.1 freezes my Mac (1997) Multiple ship to addresses (2005) A question about security (1998) cc auth with [purchase] (1998) What date is it anyway? (2004)