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:

Jimmy (1998) PIXO support (1997) [sendmail] on NT? (1997) Banner DNA (1997) [Listfiles] vs Netfinder (1997) update on wn searching (1997) Running _every_ page through WebCat-error.html (1997) Bug Report, maybe (1997) ShowNext and random sort (1998) WebCat2: multiple currency support (1997) WebMerchant & CC Response (2002) Transfering [text] variables (2000) Storefornts (1997) [authenticate] (1999) error -43 (1998) Grouping search fields, etc. (1997) Newbie problem blah blah blah (1997) Auto-closing of databases (was DON'T use old cart file!) (1997) 3RD POST Character limit in [Search]? (1998) Error:Too many nested [xxx] contexts (1997)