Simple Database close connection

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39116
interpreted = N
texte = This is stunningly simple, which is why I was surprised when it did not work. Have a scenario where updated databases are being FTP'd hourly to my server (from an AS 400 system but that is another story ;-)These DB's are read only. Meaning that NO DATA is updated via the web. I am certain of this because there is simply no templates doing anything but searching them.So like a good WebDna'r I had intended on using a closedatabase or flushdatabases tag to close down the ones in ram each hour and thus the newly delivered db's would open at the next needed viewing.But....Much to my surprise with a flush command, the ones in RAM overwrote the ones delivered! This is obviously not good.It seems I cannot specifically find a tag/way to close DB's with complete assurance that they will not be written to disk first.Am I missing something painfully obvious?All the code I write and I cant get the damn Db to close ;-) oh the irony.AlexMac... Wcat 4.xAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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:

    
  1. Re: Simple Database close connection (John Peacock 2001)
  2. Re: Simple Database close connection (Samuel Renkert 2001)
  3. Re: Simple Database close connection (Alex McCombie 2001)
  4. Re: Simple Database close connection (John Peacock 2001)
  5. Re: Simple Database close connection (Samuel Renkert 2001)
  6. Re: Simple Database close connection (John Peacock 2001)
  7. Re: Simple Database close connection (John Peacock 2001)
  8. Re: Simple Database close connection (Samuel Renkert 2001)
  9. Re: Simple Database close connection (Alex McCombie 2001)
  10. Re: Simple Database close connection (Nitai @ ComputerOil 2001)
  11. Re: Simple Database close connection (Bob Minor 2001)
  12. Re: Simple Database close connection (Scott Anderson 2001)
  13. Re: Simple Database close connection (John Peacock 2001)
  14. Re: Simple Database close connection (Scott Anderson 2001)
  15. Re: Simple Database close connection (Andrew Simpson 2001)
  16. Re: Simple Database close connection (John Peacock 2001)
  17. Re: Simple Database close connection (Scott Anderson 2001)
  18. Re: Simple Database close connection (Scott Anderson 2001)
  19. Re: Simple Database close connection (Alex McCombie 2001)
  20. Re: Simple Database close connection (John Peacock 2001)
  21. Re: Simple Database close connection (John Peacock 2001)
  22. Re: Simple Database close connection (Scott Anderson 2001)
  23. Re: Simple Database close connection (Alex McCombie 2001)
  24. Re: Simple Database close connection (Scott Anderson 2001)
  25. Re: Simple Database close connection (Alex McCombie 2001)
  26. Re: Simple Database close connection (Alex McCombie 2001)
  27. Re: Simple Database close connection (Donovan Brooke 2001)
  28. Re: Simple Database close connection (John Peacock 2001)
  29. Simple Database close connection (Alex McCombie 2001)
This is stunningly simple, which is why I was surprised when it did not work. Have a scenario where updated databases are being FTP'd hourly to my server (from an AS 400 system but that is another story ;-)These DB's are read only. Meaning that NO DATA is updated via the web. I am certain of this because there is simply no templates doing anything but searching them.So like a good WebDna'r I had intended on using a closedatabase or flushdatabases tag to close down the ones in ram each hour and thus the newly delivered db's would open at the next needed viewing.But....Much to my surprise with a flush command, the ones in RAM overwrote the ones delivered! This is obviously not good.It seems I cannot specifically find a tag/way to close DB's with complete assurance that they will not be written to disk first.Am I missing something painfully obvious?All the code I write and I cant get the damn Db to close ;-) oh the irony.AlexMac... Wcat 4.xAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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/ Alex McCombie

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:

PhotoMill -> PhotoMaster (1997) Major Security Hole IIS NT (1998) tax rate off by 1 cent (1997) Cold Fusion Buster (1997) WebMerchant 1.6 and SHTML (1997) How to unsubscribe (2000) Turning a URL into a link (2003) "&" character in Flash animation (2004) rounding onlu UP (2002) HTTP upload (2000) Quotation Marks in Database (1998) Generating Report Totals (1997) Format of Required fields error message (1997) [OT] 'Email this story to a friend' (2003) Emailer setup (1997) FlushDatabase Suggestion (1998) webdna hideif / redirect - javascript disabled (2006) [WebDNA] [BULK] db-temp files (2011) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) payment processors (2005)