Re: Simple Database close connection
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39126
interpreted = N
texte = On 10/5/01 4:52 PM, Scott Anderson
wrote:> An internal modified flag gets set the first time the cached database is > changed via WebDNA (nothing to do with the file system). Another > circumstance that might cause the modified flag to be set is if the engine > had to 'correct' a badly formatted database, i.e. rows that did not contain > the right number of columns. Bingo!Well sort of... I guess the only way I could have known this is through this conversation.I discovered that the data feed had indeed 'added' an extra column of data to the database. Now since I use the .hdr file and since that field was not located in the text... Whalla..So what you're saying is that webcat, in some way, modified the db it opened to accommodate the .hdr file description? In essence adding a tab to the end of each row? Very nice catch Scott! > The [refresh] tag would be a bit redundant in that the [closedatabase] tag > should accomplish the same thing (for a read only database). In theory, but I happen to know that I will be dealing with data sets (another project) that use databases in set format. Those DB's will need to be reverted back to the starting format after much editing. I suppose I could use the flush, move, open method for that. Of course an option such as [closedatabase db=/mydb&writeonclose=F] would be very cool. In any case.. I have corrected the .hdr file, spanked the client, and will be checking on Monday (next data send) to see if the closedb is going to do the trick.Thanks for the detailed response. That's how we deal with these :-)AlexAlex 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:
On 10/5/01 4:52 PM, Scott Anderson wrote:> An internal modified flag gets set the first time the cached database is > changed via WebDNA (nothing to do with the file system). Another > circumstance that might cause the modified flag to be set is if the engine > had to 'correct' a badly formatted database, i.e. rows that did not contain > the right number of columns. Bingo!Well sort of... I guess the only way I could have known this is through this conversation.I discovered that the data feed had indeed 'added' an extra column of data to the database. Now since I use the .hdr file and since that field was not located in the text... Whalla..So what you're saying is that webcat, in some way, modified the db it opened to accommodate the .hdr file description? In essence adding a tab to the end of each row? Very nice catch Scott! > The [refresh] tag would be a bit redundant in that the [closedatabase] tag > should accomplish the same thing (for a read only database). In theory, but I happen to know that I will be dealing with data sets (another project) that use databases in set format. Those DB's will need to be reverted back to the starting format after much editing. I suppose I could use the flush, move, open method for that. Of course an option such as [closedatabase db=/mydb&writeonclose=F] would be very cool. In any case.. I have corrected the .hdr file, spanked the client, and will be checking on Monday (next data send) to see if the closedb is going to do the trick.Thanks for the detailed response. That's how we deal with these :-)AlexAlex 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:
Quit revisited (1997)
WebMerchant (1997)
authorizenet and netscape (2002)
FAX orders (1996)
Re[2]: The max=0 issue is a bug ... (2000)
WebCat2 several catalogs? (1997)
on/off values (2000)
Webstar 1.3.1 PPC (1997)
code to phantom spacing (2001)
Date subtraction (2002)
form data submission get (1997)
using showpage and showcart commands (1996)
Fwd: Problems with Webcatalog Plug-in (1997)
WebDNA 6.x - what linux distro woudl you use? (was: (2004)
Free shipping (2000)
[WebDNA] Simple Date Format Conversion (2008)
graphics server, SSL, Netscape 4.0 (off topic) (1998)
WebCatalog for Postcards ? (1997)
Format of Required fields error message (1997)
WebCatalog.acgi quitting with error Type 2 (1998)