Re: [WebDNA] Databases not staying open
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104346
interpreted = N
texte = > I have a comma within the 'prefVALUE' for the fourth field ... I think you mean there's a comma in the prefVALUE field of the fourth RECORD ... :) > Is it documented anywhere that > commas cannot be used in values within WebDNA tables? No, and I think tables are supposed to work just like db's, so unless there was some kind of illegal character in there along with the comma, this limitation should probably be documented -- if in fact it is a real limitation. > What makes this more odd is that the template worked no problem on a Mac. > The site was transferred to a Linux box running CentOS and WebDNA 6.2 on > Friday. Then perhaps it could be a line ending issue rather than a comma issue. > The other complication was that this template was being hit by a > trigger once a day at 16:05. The trigger was set at the standard retry at > ten second intervals and timeout after 30 secs, but it would appear that the > trigger just kept hitting the page constantly causing the databases to be > constantly closed. That's why the template was continually closing the databases. Without the trigger this problem would only have occurred infrequently, and the timeouts may never have occurred. > I fixed it by removing the fourth field ... Record, not field! > ... from the table and then adding it using [append] - someone > mentioned this method on the list in the past. This should not be necessary if the table were written correctly from the beginning. Maybe the problem really stems from the comma (are commas actually field delimiters in tables???) ... but it seems more likely that there was an illegal character in the fourth record and when you removed that record you also removed the illegal character. Sincerely, Kenneth Grome www.KenGrome.com
Associated Messages, from the most recent to the oldest:
> I have a comma within the 'prefVALUE' for the fourth field ... I think you mean there's a comma in the prefVALUE field of the fourth RECORD ... :) > Is it documented anywhere that > commas cannot be used in values within WebDNA tables? No, and I think tables are supposed to work just like db's, so unless there was some kind of illegal character in there along with the comma, this limitation should probably be documented -- if in fact it is a real limitation. > What makes this more odd is that the template worked no problem on a Mac. > The site was transferred to a Linux box running CentOS and WebDNA 6.2 on > Friday. Then perhaps it could be a line ending issue rather than a comma issue. > The other complication was that this template was being hit by a > trigger once a day at 16:05. The trigger was set at the standard retry at > ten second intervals and timeout after 30 secs, but it would appear that the > trigger just kept hitting the page constantly causing the databases to be > constantly closed. That's why the template was continually closing the databases. Without the trigger this problem would only have occurred infrequently, and the timeouts may never have occurred. > I fixed it by removing the fourth field ... Record, not field! > ... from the table and then adding it using
[append] - someone > mentioned this method on the list in the past. This should not be necessary if the table were written correctly from the beginning. Maybe the problem really stems from the comma (are commas actually field delimiters in tables???) ... but it seems more likely that there was an illegal character in the fourth record and when you removed that record you also removed the illegal character. Sincerely, Kenneth Grome www.KenGrome.com
Kenneth Grome
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:
Post arguments problem mac? (1997)
[protect admin] (1997)
SKU lookup (1997)
Searchable WebCat (etc.) Docs ? (1997)
Still Stumped on ShowNext...HELP! (1997)
First postarg not taking in $Commands (1997)
remove.htm from result (2005)
Bug reported on June 6, 2000 still not fixed ... (2000)
Verifying both name and password (was: New Problem) (1997)
about this server and links to who (1997)
Rounding question (2002)
Grant, please help me ... (1997)
Getting real time CC's out of Australia (1998)
Greeting Card System (2000)
Multiple Pulldowns (1997)
Banners and sort of random display (1997)
[WebDNA] hideif within a search (2009)
Order not created error (1997)
Where is f2? (1997)
bug in [SendMail] (1997)