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

Search Engine questions ... (2002) WebCat2: Items xx to xx shown, etc. (1997) To Err or Not Custom Error (1999) Unknown exception in WebDNA 4.5.0 (2003) Multiple catalog databases and showcart (1997) Re[2]: OT: Sending email to lots of subscribers (1999) problem: mail changed (1997) [WebDNA] Sort Direction matches the written to file order (2015) carriage returns in data (1997) Bug Report, maybe (1997) OLD ORDERS (1998) Date Range Issue (2006) The code, one more time. (2003) Problems reading files created by WC (1997) Searching multiple records for certain info (2000) Emailer help....! (1997) Help formatting search results w/ table (1997) [OT] MacWorld Expo (2004) random prob (2003) Generating Options for a Form. (1997)