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 onedirectory 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 filewill create an include file, loop through the directories in the virtualhost and close the databases (.db files), then deletes the include file itwrote (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:
Now, just in case your users do not have all their .db files in onedirectory 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 filewill create an include file, loop through the directories in the virtualhost and close the databases (.db files), then deletes the include file itwrote (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)