Re: Simple Database close connection
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39128
interpreted = N
texte = Thanks, but the credit should go to an old friend who pointed out other reasons the 'modified' flag may get set.> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Alex McCombie > Sent: Friday, October 05, 2001 2:04 PM > To: WebCatalog Talk > Subject: Re: Simple Database close connection > > > 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 :-) > > Alex > > > > > > Alex J McCombie New World Media > Chief Information Officer Drawer 607 > 800/724.8973 Fair Haven, NY 13064 > Alex@NewWorldMedia.com http://OurClients.com > > Interface 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/------------------------------------------------------------- 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:
Thanks, but the credit should go to an old friend who pointed out other reasons the 'modified' flag may get set.> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Alex McCombie > Sent: Friday, October 05, 2001 2:04 PM > To: WebCatalog Talk > Subject: Re: Simple Database close connection > > > 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 :-) > > Alex > > > > > > Alex J McCombie New World Media > Chief Information Officer Drawer 607 > 800/724.8973 Fair Haven, NY 13064 > Alex@NewWorldMedia.com http://OurClients.com > > Interface 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/------------------------------------------------------------- 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/
Scott Anderson
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:
Referrer from multiple entry points (1998)
Sorting Numbers (1997)
Can't find templaes (1997)
did I miss anything (1997)
Universal db access template ... (2002)
Monitor Hard Disk Space? (2003)
Help! WebCat2 bug (1997)
WebSTAR 2.1 freezes my Mac (1997)
[OT] Ratings comparison? (2003)
Rollovers (1999)
Vann's - nice new WebCatalog site (1998)
WebCat2 beta 11 - new prefs ... (1997)
WebCat2final1 crashes (1997)
form data submission gets truncated (1997)
all records returned. (1997)
[WebDNA] snow (2009)
Tax on Shipping question (1998)
Guestbook (2000)
Search: Is this possible? (2005)
Searching (2005)