Re: [WebDNA] Escaping content for JSON
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110283
interpreted = N
texte = --047d7b67809ebdd95304d8d27433 Content-Type: text/plain; charset=UTF-8 Donovan, Thanks - that looks pretty good - I'll have a detailed look later on. Would be great if [convertchars] could deal with double-byte encodings ;-) Take care - Tom ============================================== Digital Revolutionaries 1st Floor, Castleriver House 14-15 Parliament Street Temple Bar,Dublin 2 Ireland ---------------------------------------------- [t]: + 353 1 4403907 [e]:
[w]: ============================================== On 26 March 2013 05:54, Donovan Brooke wrote: > Tom Duke wrote: > >> Hi all, >> >> Trying to work out the best method of preparing content for use with >> JSON. My db charset is UTF-8 and it seems I need to use a >> [convertwords] and a [convertchars] to escape all of the required chars. >> >> Double quotes are not captured if I use just [convertchars]. Wondering >> if anyone else has come up with a cleaner solution. >> >> Thanks >> - Tom >> >> >> Conversion tables: >> >> [table name=jsonconvert&fields=from,**to] >> "\" >> \\\ >> /\/ >> [/table] >> >> [table name=jsonconvert2&fields=from,**to] >> %0B\n >> [/table] >> >> >> JSON output: >> >> { >> "label": "Title:", >> "name": "[convertchars table=jsonconvert2][**convertwords >> table=jsonconvert][theTitle][/**convertwords][/convertchars]" >> } >> > > > > Tom, > Here is what I came up with tonight: > > http://www.euca.us/admin/**tests/json_test.html > > Donovan > > > > > > -- > Donovan Brooke > WebDNA Software Corporation > http://www.webdna.us > **[Square Bracket Utopia]** > ------------------------------**--------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/**talk@webdna.us > Bug Reporting: support@webdna.us > --047d7b67809ebdd95304d8d27433 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Donovan,
Thanks - that looks pret= ty good - I'll have a detailed look later on. =C2=A0 Would be great if = [convertchars] could deal with double-byte encodings ;-)
Take care
- Tom
On 26 March 2013 05:54, Donovan Brooke <= span dir=3D"ltr"><
dbrooke@webdna.us> wrote:
Tom Duke wrote:
Hi all,
Trying to work out the best method of preparing content for use with
JSON. =C2=A0 My db charset is UTF-8 and it seems I need to use a
[convertwords] and a [convertchars] to escape all of the required chars.
Double quotes are not captured if I use just [convertchars]. =C2=A0Wonderin= g
if anyone else has come up with a cleaner solution.
Thanks
- Tom
Conversion tables:
[table name=3Djsonconvert&fields=3Dfrom,to]
"\"
\\\
/\/
[/table]
[table name=3Djsonconvert2&fields=3Dfrom,to]
%0B\n
[/table]
JSON output:
{
"label": "Title:",
"name": "[convertchars table=3Djsonconvert2][convertw= ords
table=3Djsonconvert][theTitle][/convertwords][/convertchars]" }
Here is what I came up with tonight:
http://www.euca.us/admin/tests/json_test.html
Donovan
--
Donovan Brooke
WebDNA Software Corporation
http://www.webdna.us=
**[Square Bracket Utopia]**
---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: suppo= rt@webdna.us
--047d7b67809ebdd95304d8d27433--
Associated Messages, from the most recent to the oldest: