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

Ken's Data Manager (finally available I think ...) (2005) [Sum] function? (1997) Can't find templaes (1997) WebCat2 several catalogs? (1997) [WebDNA] MD5 Hash issue (2009) Clickable maps and WebCatalog? (1996) Reversed words (1997) Running _every_ page through WebCat ? (1997) test (2003) MacActivity and PCS (1997) BGcolor (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Passing Cart variable to subdirectory files? (1997) $Replace with [founditems] (1997) WebCat2 beta 11 - new prefs ... (1997) Variable prices and Formulas.db (1997) pdf files? (2001) [OT] Discussion forum, last visit, Cookie, ... (2003) Pirated WebCat? NOT... (2003) Sending an email to all )or some) email addresses int he database (1999)