[WebDNA] Problem Retrieving data out of MySQL

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110806
interpreted = N
texte = --Apple-Mail=_9B0818C4-8EC7-4BFB-9B8C-EF235C85E244 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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=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 Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au --Apple-Mail=_9B0818C4-8EC7-4BFB-9B8C-EF235C85E244 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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
webdna@idfk.com.au




= --Apple-Mail=_9B0818C4-8EC7-4BFB-9B8C-EF235C85E244-- 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=_9B0818C4-8EC7-4BFB-9B8C-EF235C85E244 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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=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 Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au --Apple-Mail=_9B0818C4-8EC7-4BFB-9B8C-EF235C85E244 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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




= --Apple-Mail=_9B0818C4-8EC7-4BFB-9B8C-EF235C85E244-- 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:

founditems (2000) WebCatalog NT (1996) VeriSign News (2002) Problems appending to database (1997) math problems (2000) Interfacing WebMerchant to www.fedex.com (1997) Most Efficiant Way to do restricted Areas (1997) expired beta (1997) WC1.6 to WC2 date formatting (1997) AJAX with WebDNA (2006) [Announce]: Web server security and password protection (1997) error: Too many nested [xxx] contexts (1997) Storebuilder documentation (2004) Too many webcat comments. [WAS- Large founditems loops] (2000) Document Contains No Data (1998) 2.01 upgrade problems (1997) old 3.0 mac license for sale? (2003) Week # problem (1998) Replace context problem ... (1997) Formating found categories (1997)