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

WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Online Docs? (1997) Multiple Users.db Possible? (1997) Showif, Hideif reverse logic ? (1997) Download URL & access on the fly ? (1997) Ok here is a question? (1997) billing system (2003) [SHOWIF] (1997) WebCat2 as a chat server? (1997) AppleScript question (1997) Re:2nd WebCatalog2 Feature Request (1996) Find all in search. (2002) Accepting credit cards (1997) Limiting user access to .tmpl files (1997) filemaker - orderfile (1997) [TIME] not working (2007) [WebDNA] [ipaddress] - [RealIP] - Not working properly (2016) WebCatalog for Postcards ? (1997) [WebDNA] Listwords and newline (2011) append=T problem (1998)