Re: CloseDataBase vs CommitDataBase
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 68850
interpreted = N
texte = >As for [closedatabase], there shouldn't be much use for it, unless you have >issues with the same database being opened multiple times, like I do. For me, [closedatabases] (invoked with a link) is essential when I'm developing a site and doing frequent manual editing of the db file (fixing mistakes, changing fieldnames, entering dummy data, etc.). After I do my edit, I hit the [closedatabase] so the next time the db is accessed, it has the most current version. Once a site is up and running though, I don't use it in my code. Actually, I have boilerplate development code that appears at the bottom of all my pages (only for my IP) that begins with a closedb link, followed by listings of formvariables, listvariables, and cookies. > In my case, each instance has a different path (one instance has an exact >path, while one has a virtual path), but they are the same database. WebCat definitely sees this as two different databases. Use the same path, even if you have to stash the DB in globals, if different sites use it. I've been through this the hard way and know it to be true. Terry -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- 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:
>As for [closedatabase], there shouldn't be much use for it, unless you have >issues with the same database being opened multiple times, like I do. For me, [closedatabases] (invoked with a link) is essential when I'm developing a site and doing frequent manual editing of the db file (fixing mistakes, changing fieldnames, entering dummy data, etc.). After I do my edit, I hit the [closedatabase] so the next time the db is accessed, it has the most current version. Once a site is up and running though, I don't use it in my code. Actually, I have boilerplate development code that appears at the bottom of all my pages (only for my IP) that begins with a closedb link, followed by listings of formvariables, listvariables, and cookies. > In my case, each instance has a different path (one instance has an exact >path, while one has a virtual path), but they are the same database. WebCat definitely sees this as two different databases. Use the same path, even if you have to stash the DB in globals, if different sites use it. I've been through this the hard way and know it to be true. Terry -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- 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/
Terry Wilson
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:
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
WebCat2b12--[searchstring] bug (1997)
Roundup function? (1997)
PCS Emailer's role ? (1997)
Secure Server (1997)
taxrate - off by 1 cent (1997)
Seeking NT Mail Server Experiences (1998)
Dates! (1998)
two unique banners on one page (1997)
multiple search commands (1997)
form image (2000)
remotely add + sign (1997)
snicker, snicker (1997)
Quantity (1998)
ShipCosts database (1997)
[Sum] function? (1997)
shipcost (1997)
Search for 20 finds 2000, 200 Why? (1997)
when is date system date or order date? (1997)
Satistics (1999)