Re: [WebDNA] Problem Retrieving data out of MySQL

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110807
interpreted = N
texte = --Apple-Mail=_C886A814-D556-41D1-924F-83608DAAD220 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii SOLVED. This is what I did. I created a second query exclusively to extract the T3C_BODY Select CONCAT(CAST(t3collections.T3C_BODY AS CHAR)) As _BODY from = t3collections WHERE T3C_ID =3D [_ID]; Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 11/10/2013, at 2:49 PM, WebDNA wrote: > This works perfectly: >=20 > [SQLExecute conn_ref=3DTOP3DATA&result_var=3DRES-CONTENT] > SELECT * > FROM t3collections > WHERE T3C_ID =3D [_ID]; > [/SQLExecute] > [SQLResult result_ref=3DRES-CONTENT] > [FOUNDITEMS] > [T3C_MENUNAME] > [TEXT]_MENUNAME=3D[T3C_MENUNAME][/TEXT] > [TEXT]_STARTDATE=3D[HIDEIF = [URL][T3C_STARTDATE][/URL]=3D][FORMAT = days_to_date][T3C_STARTDATE][/FORMAT][/HIDEIF][/TEXT] > [TEXT]_ENDDATE=3D[HIDEIF = [URL][T3C_ENDDATE][/URL]=3D][FORMAT = days_to_date][T3C_ENDDATE][/FORMAT][/HIDEIF][/TEXT] > [TEXT]_TITLE=3D[T3C_TITLE][/TEXT] > [TEXT]_URL=3D[T3C_URL][/TEXT] > [TEXT]_HEROIMAGE=3D[T3C_HEROIMAGE][/TEXT] > [/FOUNDITEMS] > [/SQLResult] >=20 > But as soon as I add >=20 > [TEXT]__BODY=3D[T3C_BODY][/TEXT] >=20 > into the list the page crashes. >=20 > T3C_BODY is storing TEXTAREA data that has been formatted using TinyMC >=20 > Any ideas ? >=20 >=20 >=20 >=20 >=20 >=20 > Regards >=20 > Stuart Tremain=20 >=20 > IDFK Web Developments > 114 Christie Street, St Leonards NSW 2065. Australia > phone: +612 8971 4431 > fax: +612 8088 6092 > skype: stuarttremain > www.idfk.com.au >=20 >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_C886A814-D556-41D1-924F-83608DAAD220 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii SOLVED.

This is what I = did.

I created a second query exclusively to = extract the T3C_BODY

Select = CONCAT(CAST(t3collections.T3C_BODY AS  CHAR))  As _BODY from = t3collections WHERE T3C_ID =3D [_ID];


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 11/10/2013, at 2:49 PM, WebDNA <webdna@idfk.com.au> = wrote:

This = works perfectly:

[SQLExecute = conn_ref=3DTOP3DATA&result_var=3DRES-CONTENT]
= SELECT *
FROM = t3collections
WHERE T3C_ID =3D = [_ID];
= [/SQLExecute]
[SQLResult = result_ref=3DRES-CONTENT]
= [FOUNDITEMS]
= [T3C_MENUNAME]
= [TEXT]_MENUNAME=3D[T3C_MENUNAME][/TEXT]
= [TEXT]_STARTDATE=3D[HIDEIF [URL][T3C_STARTDATE][/URL]=3D][FORMAT = days_to_date][T3C_STARTDATE][/FORMAT][/HIDEIF][/TEXT]
= [TEXT]_ENDDATE=3D[HIDEIF [URL][T3C_ENDDATE][/URL]=3D][FORMAT = days_to_date][T3C_ENDDATE][/FORMAT][/HIDEIF][/TEXT]
= [TEXT]_TITLE=3D[T3C_TITLE][/TEXT]
= [TEXT]_URL=3D[T3C_URL][/TEXT]
= [TEXT]_HEROIMAGE=3D[T3C_HEROIMAGE][/TEXT]
= [/FOUNDITEMS]
= [/SQLResult]

But as soon as I = add

[TEXT]__BODY=3D[T3C_BODY][/TEXT]
into the list the page = crashes.

T3C_BODY is storing TEXTAREA data that = has been formatted using TinyMC

Any ideas = ?





Regards

Stuart Tremain

IDFK Web = Developments
114 Christie Street, St Leonards NSW 2065. = Australia
phone: +612 8971 4431
fax: +612 8088 6092
skype: stuarttremain
www.idfk.com.au



Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_C886A814-D556-41D1-924F-83608DAAD220-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Problem Retrieving data out of MySQL (WebDNA 2013)
  2. [WebDNA] Problem Retrieving data out of MySQL (WebDNA 2013)
--Apple-Mail=_C886A814-D556-41D1-924F-83608DAAD220 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii SOLVED. This is what I did. I created a second query exclusively to extract the T3C_BODY Select CONCAT(CAST(t3collections.T3C_BODY AS CHAR)) As _BODY from = t3collections WHERE T3C_ID =3D [_ID]; Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 11/10/2013, at 2:49 PM, WebDNA wrote: > This works perfectly: >=20 > [SQLExecute conn_ref=3DTOP3DATA&result_var=3DRES-CONTENT] > SELECT * > FROM t3collections > WHERE T3C_ID =3D [_ID]; > [/SQLExecute] > [SQLResult result_ref=3DRES-CONTENT] > [founditems] > [T3C_MENUNAME] > [text]_MENUNAME=3D[T3C_MENUNAME][/TEXT] > [text]_STARTDATE=3D[HIDEIF = [url][T3C_STARTDATE][/URL]=3D][FORMAT = days_to_date][T3C_STARTDATE][/FORMAT][/HIDEIF][/TEXT] > [text]_ENDDATE=3D[HIDEIF = [url][T3C_ENDDATE][/URL]=3D][FORMAT = days_to_date][T3C_ENDDATE][/FORMAT][/HIDEIF][/TEXT] > [text]_TITLE=3D[T3C_TITLE][/TEXT] > [text]_URL=3D[T3C_URL][/TEXT] > [text]_HEROIMAGE=3D[T3C_HEROIMAGE][/TEXT] > [/FOUNDITEMS] > [/SQLResult] >=20 > But as soon as I add >=20 > [text]__BODY=3D[T3C_BODY][/TEXT] >=20 > into the list the page crashes. >=20 > T3C_BODY is storing TEXTAREA data that has been formatted using TinyMC >=20 > Any ideas ? >=20 >=20 >=20 >=20 >=20 >=20 > Regards >=20 > Stuart Tremain=20 >=20 > IDFK Web Developments > 114 Christie Street, St Leonards NSW 2065. Australia > phone: +612 8971 4431 > fax: +612 8088 6092 > skype: stuarttremain > www.idfk.com.au >=20 >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_C886A814-D556-41D1-924F-83608DAAD220 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii SOLVED.

This is what I = did.

I created a second query exclusively to = extract the T3C_BODY

Select = CONCAT(CAST(t3collections.T3C_BODY AS  CHAR))  As _BODY from = t3collections WHERE T3C_ID =3D [_ID];


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 11/10/2013, at 2:49 PM, WebDNA <webdna@idfk.com.au> = wrote:

This = works perfectly:

[SQLExecute = conn_ref=3DTOP3DATA&result_var=3DRES-CONTENT]
= SELECT *
FROM = t3collections
WHERE T3C_ID =3D = [_ID];
= [/SQLExecute]
[SQLResult = result_ref=3DRES-CONTENT]
= [T3C_MENUNAME]
= [text]_MENUNAME=3D[T3C_MENUNAME][/TEXT]
= [text]_STARTDATE=3D[HIDEIF [url][T3C_STARTDATE][/URL]=3D][FORMAT = days_to_date][T3C_STARTDATE][/FORMAT][/HIDEIF][/TEXT]
= [text]_ENDDATE=3D[HIDEIF [url][T3C_ENDDATE][/URL]=3D][FORMAT = days_to_date][T3C_ENDDATE][/FORMAT][/HIDEIF][/TEXT]
= [text]_TITLE=3D[T3C_TITLE][/TEXT]
= [text]_URL=3D[T3C_URL][/TEXT]
= [text]_HEROIMAGE=3D[T3C_HEROIMAGE][/TEXT]
= [/FOUNDITEMS]
= [/SQLResult]

But as soon as I = add

[text]__BODY=3D[T3C_BODY][/TEXT]
into the list the page = crashes.

T3C_BODY is storing TEXTAREA data that = has been formatted using TinyMC

Any ideas = ?





Regards

Stuart Tremain

IDFK Web = Developments
114 Christie Street, St Leonards NSW 2065. = Australia
phone: +612 8971 4431
fax: +612 8088 6092
skype: stuarttremain
www.idfk.com.au



Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_C886A814-D556-41D1-924F-83608DAAD220-- WebDNA

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:

carriage returns in data (1997) WebCat2b15MacPlugin - [protect] (1997) why do I get authorization requests, even though (1999) Limit on nested [ShowIf]'s? (1997) & in Lookups (1997) Problems with [Applescript] (1997) You *can!!* overwrite username/password using an HTML form. Also, experts *please* see Q at end (2000) New Problem (1997) Username for Admin Group (1997) Emailer help....! (1997) Show if time tags (1997) [HIDEIF] inside [FOUNDITEM] (1997) Warning: Mac OS X 10.2.4 Update Overwrites Apache'shttpd.conf (2003) Selected Item in Pop-down (2003) Calender code (2005) breaking & sorting (2000) Email Not Being Sent (2004) Stopping bad HTML propagation ? (1997) Problem with encrypted cookies (2000) Couple of questions (1999)