[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:

[WebDNA] test (2017) Three new problems, maybe a fourth (1997) [WebDNA] grep again (2010) Re:FYI: Error message (1996) SendMail - Idea (2000) Country & Ship-to address & other fields ? (1997) Size limit for tmpl editor ? (1997) Problems getting parameters passed into email. (1997) ShowNext (1997) Variables for chat (1997) Document Contains No Data! (1997) one item in several different categories? (2000) WebCat2b13MacPlugIn - syntax to convert date (1997) [taxrate] question (1997) [SearchString] (1998) expired beta (1997) ShippingCosts (1998) [WebDNA] [OT] the "Work in progress" thread. (2009) RE: E-mailer error codes (1997) Alternative to Authorize.net (2002)