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] > 1 formID formcontact > 2 formTITLE The title for the form > 3 formMAILFROM no-reply@revolutionaries.ie > 4 formMAILTO email1@revolutionaries.ie,email2@revolutionaries.ie > 5 formMAILBCC emailfrom@revolutionaries.ie > 6 formCLIENT The client > 7 formMAILSPAM F > [/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... =
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
2 formTITLE The title = for the form
4
= formMAILTO
= email1@revolutionaries.ie,
email2@revolutionaries.ie 6 = formCLIENT= The client
7 formMAILSPAM F
= [/table][!]
[/!][search = table=3DformPREFS&neprefIDdatarq=3Dfind_all][founditems][text][prefTIT= LE]=3D[prefVALUE][/text][/founditems][/search]
=
= --Apple-Mail-3--691498706--
Associated Messages, from the most recent to the oldest:
--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] > 1 formID formcontact > 2 formTITLE The title for the form > 3 formMAILFROM no-reply@revolutionaries.ie > 4 formMAILTO email1@revolutionaries.ie,email2@revolutionaries.ie > 5 formMAILBCC emailfrom@revolutionaries.ie > 6 formCLIENT The client > 7 formMAILSPAM F > [/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