Progress !! WAS: Trouble with formula.db

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 10987
interpreted = N
texte = Hi Grant and everyone else,last night Curt and I finally got past the troublesome formula which would work in a .tmpl but not in the formula.db :-)We didn't keep a complete trace of all the versions we tried, but it seems as if the last formula in the database, just above the one we were trying to get to work, somehow clobbered it. IOW, it wasn't the formula we were working on that had a problem, but the prior one in the database.I suspect that some control character (an extra tab or something like that) after the prior formula was to blame.We found the problem when Curt out of desperation replaced the whole gory formula with a number and it still didn't work. I asked him (over InterNet Phone) if it was safe for me to do an edit from my end, to make sure we weren't both editing the same file at the same time since we're using SiteEdit for all of this. He gave me the goahead and I just cut the entry from the end of the database and put it at the head. It worked !Once it worked with just the plain number, we (Curt) put the formula back in and after a few missteps we had it all in working order.I should mention that the formula which apparently had the hidden, extraneous control character, worked and still works fine, so it gave no hint that it was the cause of our agony.Boy do we feel a lot better, now we can proceed :-)-Sven_____________________________________________________________________ Sven U. Grenander BeeHive Technologies, Inc. http://www.bzzzzzz.com - with a WebCam in Pasadena, California_____________________________________________________________________ Associated Messages, from the most recent to the oldest:

Re: Progress !! WAS: Trouble with formula.db (Sven U. Grenander 1997) Re: Progress !! WAS: Trouble with formula.db (Grant Hulbert 1997) Progress !! WAS: Trouble with formula.db (Sven U. Grenander 1997)

Hi Grant and everyone else,last night Curt and I finally got past the troublesome formula which would work in a .tmpl but not in the formula.db :-)We didn't keep a complete trace of all the versions we tried, but it seems as if the last formula in the database, just above the one we were trying to get to work, somehow clobbered it. IOW, it wasn't the formula we were working on that had a problem, but the prior one in the database.I suspect that some control character (an extra tab or something like that) after the prior formula was to blame.We found the problem when Curt out of desperation replaced the whole gory formula with a number and it still didn't work. I asked him (over InterNet Phone) if it was safe for me to do an edit from my end, to make sure we weren't both editing the same file at the same time since we're using SiteEdit for all of this. He gave me the goahead and I just cut the entry from the end of the database and put it at the head. It worked !Once it worked with just the plain number, we (Curt) put the formula back in and after a few missteps we had it all in working order.I should mention that the formula which apparently had the hidden, extraneous control character, worked and still works fine, so it gave no hint that it was the cause of our agony.Boy do we feel a lot better, now we can proceed :-)-Sven_____________________________________________________________________ Sven U. Grenander BeeHive Technologies, Inc. http://www.bzzzzzz.com - with a WebCam in Pasadena, California_____________________________________________________________________ Sven U. Grenander

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:

unable to launch acgi in WebCat (1997) URL for Discussion Archive (1997) Nested [SEARCH] and [REPLACE] problem. (1997) [sendmail] possible modification needed... (2000) Banner system (2000) WebCat2b12 - nesting [tags] (1997) Need relative path explanation (1997) Re:2nd WebCatalog2 Feature Request (1996) acrobat -> wc (1998) [LOOKUP] (1997) [if] and [showif] (2002) Multi-Row Tables from a search. (1997) WebDNA Developer Resource Center (2002) Suffix Mapping (1997) Warning: 50 [MATH] Variable Limit per page (1998) Dumb Question about Docs (1997) HELP (2000) Need relative path explanation (1997) Site / Database Structure (2002) Comments in db? (1997)