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:

    
  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)
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:

suffix mapping for NT? (1997) Thanks Grant (1997) MacAuthorize order data fields WAS:How To question... (1997) Quit revisited (1997) Searching Records by Company (2000) update on wn searching (1997) WCS Newbie question (1997) Summing fields (1997) Roundup (2001) Sendmail: bounced e-mails (2001) Cart Numbers (1997) Re:Help name our technology! (1997) Problems getting parameters passed into email. (1997) Problems reading files created by WC (1997) Great product and great job ! (1997) How flexible is Shipping? (1997) Moment of Thanks (1997) selectively replacing records within a [founditems] (2000) DDEConnect and MSWord (1998) expired beta (1997)