Re: [WebDNA] Databases not staying open

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104344
interpreted = N
texte = --Apple-Mail-3--691498706 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Hi Tom you mean 4th *record* (3rd field), where you were saying "4th field". ...anyway maybe it will solve it by [url]ing the value you stuff in the offending [table] field(s) and then [unurl]ing later down where you spit the value out. I have got myself out of various kinds of hotwater using [table] by this method... -G On Jan 11, 2010, at 10:15 AM, Tom Duke wrote: > Hi all, > > Ok found the code that was causing the problem (below). I have a > comma within the 'prefVALUE' for the fourth field - the template > chokes on this and causes all databases to be closed. Is it > documented anywhere that commas cannot be used in values within > WebDNA tables? > > 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. 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. > > I fixed it by removing the fourth field from the table and then > adding it using [append] - someone mentioned this method on the list > in the past. > > - Tom > > > > > [!] > > > ------------------------------------ > ### Set the form prefs ### > > [/!][table name=formPREFS&fields=prefID,prefTITLE,prefVALUE] > 1formIDformcontact > 2formTITLEThe title for the form > 3formMAILFROMno-reply@revolutionaries.ie > 4formMAILTOemail1@revolutionaries.ie,email2@revolutionaries.ie > 5formMAILBCCemailfrom@revolutionaries.ie > 6formCLIENTThe client > 7formMAILSPAMF > [/table][!] > > [/!][search table=formPREFS&neprefIDdatarq=find_all][founditems] > [text][prefTITLE]=[prefVALUE][/text][/founditems][/search] ------------ Govinda govinda.webdnatalk@gmail.com --Apple-Mail-3--691498706 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi Tom

you = mean 4th *record* (3rd field), where you were saying "4th = field".
...anyway maybe it will solve it by [url]ing the value = you stuff in the offending [table] field(s) and then [unurl]ing later = down where you spit the value out.
I have got myself out of = various kinds of hotwater using [table] by this method... =  

-G

On Jan 11, = 2010, at 10:15 AM, Tom Duke wrote:

Hi = all,

Ok found the code that was causing the problem = (below).  I have a comma within the 'prefVALUE' for the fourth = field - the template chokes on this and causes all databases to be = closed.  Is it documented anywhere that commas cannot be used in = values within WebDNA tables?

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. =  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.

I fixed it = by removing the fourth field from the table and then adding it using = [append] - someone mentioned this method on the list in the = past.

- Tom

=


[!]

=

= ------------------------------------
### =  Set the form prefs  ###

[/!][table = name=3DformPREFS&fields=3DprefID,prefTITLE,prefVALUE]
1= formID= formcontact
2formTITLEThe title = for the form




= --Apple-Mail-3--691498706-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Databases not staying open (Donovan Brooke 2010)
  2. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  3. Re: [WebDNA] Databases not staying open (christophe.billiottet@webdna.us 2010)
  4. Re: [WebDNA] Databases not staying open (Govinda 2010)
  5. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  6. Re: [WebDNA] Databases not staying open (christophe.billiottet@webdna.us 2010)
  7. Re: [WebDNA] Databases not staying open (Govinda 2010)
  8. Re: [WebDNA] Databases not staying open (christophe.billiottet@webdna.us 2010)
  9. Re: [WebDNA] Databases not staying open (Donovan Brooke 2010)
  10. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  11. Re: [WebDNA] Databases not staying open (Govinda 2010)
  12. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  13. Re: [WebDNA] Databases not staying open (Dan Strong 2010)
  14. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  15. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  16. Re: [WebDNA] Databases not staying open (Dan Strong 2010)
  17. Re: [WebDNA] Databases not staying open (Govinda 2010)
  18. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  19. Re: [WebDNA] Databases not staying open (Donovan Brooke 2010)
  20. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  21. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  22. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  23. Re: [WebDNA] Databases not staying open (Tom Duke 2010)
  24. Re: [WebDNA] Databases not staying open (christophe.billiottet@webdna.us 2010)
  25. Re: [WebDNA] Databases not staying open (Kenneth Grome 2010)
  26. [WebDNA] Databases not staying open (Tom Duke 2010)
--Apple-Mail-3--691498706 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Hi Tom you mean 4th *record* (3rd field), where you were saying "4th field". ...anyway maybe it will solve it by
[url]ing the value you stuff in the offending
[table] field(s) and then [unurl]ing later down where you spit the value out. I have got myself out of various kinds of hotwater using [table] by this method... -G On Jan 11, 2010, at 10:15 AM, Tom Duke wrote: > Hi all, > > Ok found the code that was causing the problem (below). I have a > comma within the 'prefVALUE' for the fourth field - the template > chokes on this and causes all databases to be closed. Is it > documented anywhere that commas cannot be used in values within > WebDNA tables? > > 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. 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. > > I fixed it by removing the fourth field from the table and then > adding it using [append] - someone mentioned this method on the list > in the past. > > - Tom > > > > > [!] > > > ------------------------------------ > ### Set the form prefs ### > > [/!][table name=formPREFS&fields=prefID,prefTITLE,prefVALUE] > 1formIDformcontact > 2formTITLEThe title for the form > 3formMAILFROMno-reply@revolutionaries.ie > 4formMAILTOemail1@revolutionaries.ie,email2@revolutionaries.ie > 5formMAILBCCemailfrom@revolutionaries.ie > 6formCLIENTThe client > 7formMAILSPAMF > [/table][!] > > [/!][search table=formPREFS&neprefIDdatarq=find_all][founditems] > [text][prefTITLE]=[prefVALUE][/text][/founditems][/search] ------------ Govinda govinda.webdnatalk@gmail.com --Apple-Mail-3--691498706 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi Tom

you = mean 4th *record* (3rd field), where you were saying "4th = field".
...anyway maybe it will solve it by [url]ing the value = you stuff in the offending [table] field(s) and then [unurl]ing later = down where you spit the value out.
I have got myself out of = various kinds of hotwater using [table] by this method... =  

-G

On Jan 11, = 2010, at 10:15 AM, Tom Duke wrote:

Hi = all,

Ok found the code that was causing the problem = (below).  I have a comma within the 'prefVALUE' for the fourth = field - the template chokes on this and causes all databases to be = closed.  Is it documented anywhere that commas cannot be used in = values within WebDNA tables?

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. =  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.

I fixed it = by removing the fourth field from the table and then adding it using = [append] - someone mentioned this method on the list in the = past.

- Tom

=



=

= ------------------------------------
### =  Set the form prefs  ###

[/!][table = name=3DformPREFS&fields=3DprefID,prefTITLE,prefVALUE]
1= formID= formcontact
2formTITLEThe title = for the form
4= formMAILTO= email1@revolutionaries.ie,email2@revolutionaries.ie
6= formCLIENT= The client
7formMAILSPAMF
=

[/!][search = table=3DformPREFS&neprefIDdatarq=3Dfind_all][founditems][text][prefTIT= LE]=3D[prefVALUE][/text][/founditems][/search]
=




= --Apple-Mail-3--691498706-- Govinda

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:

Two SynchThreads prefs (2000) WebCat2b13MacPlugIn - More limits on [include] (1997) Post size Limit? (1998) [OT] Who's got a cool link (2002) Cybersource and WebCat ... again (2000) PSC recommends what date format yr 2000??? (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) Items XX to XX shown (1997) problems with 2 tags shakur (1997) [WriteFile] problems (1997) E-mail loop ! (1997) Server Load (2000) process SSI (1998) Faxing orders in place of email (1997) Authenticate (2000) Where's Cart Created ? (1997) Adding discount to cart (2000) Re:trouble (1997) emailer settings and control questions (1997) Showif -what am I missing??? (1999)