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:

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

RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error (2019) RE: Languages (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Progress !! WAS: Trouble with formula.db (1997) WebCat2b15MacPlugin - [protect] (1997) textarea inputs and returns (1999) docs for WebCatalog2 (1997) WebCat2 - Getting to the browser's username/password data (1997) WebCat2 several catalogs? (1997) WebCat2b12 - nesting [tags] (1997) Blank orders after update to 5.1 (2003) Another bug to squash (WebCat2b13 Mac .acgi) (1997) WebCAT MacOS9 --> OSX (2003) HTML Editors (1997) Emailer setup (1997) Error with [applescript] (1999) Capitalize (2003) RE: [WebDNA] smtp authentication (2008) [sendmail] questions... (1997) Problems with dbcatalog.exe (1997)