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:

WebDNA on Intel Mac? (2006) What week is first? (1998) 5.0 Pricing (2003) Sorting error (1997) Limiting user access to .tmpl files (1997) mapping fields between databases (2001) Is this possible, WebCat2.0 and checkboxes (1997) Nested tags count question (1997) [replaceChars] would be nice ... (1997) WebCatalog stalls (1998) passing info to thankyou.tpl (1998) [SHOWIF AND/OR] (1997) [shownext max (1997) How Many SKU's is enough? (1997) emailer cc to figured out (1997) SAVECART (1997) Authenticate (1997) How do I get Google to crawl a WebCat site? (2003) WCS Newbie question (1997) EMail Problem (2000)