JSON value with apostrophe

jquery json coldfusion apostrophe
froadie picture froadie · Aug 27, 2012 · Viewed 8.5k times · Source

I have an element with a rel attribute that contains a JSON string, something like:

rel='{"id":"#id#","name":"#name#"}'

Then, in my javascript code, I use $.parseJSON to parse this data. This works correctly - besides for cases where name contains an apostrophe. I've tried using jsStringFormat, a coldfusion replace that replaces all single quotes with escaped single quotes, etc, but I can't seem to hit on a correct solution. I know this is probably simple, but how do I get the code to correctly pass values with apostropes/single quotes using json?

This code works, but eliminates the apostrophes which I'd like to preserve:

rel='{"id":"#id#","name":"#replace(name,"'","","all")#"}'

This does not work:

rel='{"id":"#id#","name":"#replace(name,"'","\'","all")#"}'

Nor does:

rel='{"id":"#id#","name":"#replace(name,"'","\\\'","all")#"}'

Or:

rel='{"id":"#id#","name":"#replace(name,"'",""","all")#"}'

Or:

rel='{"id":"#id#","name":"#jsStringFormat(name)#"}'

Answer

froadie picture froadie · Aug 27, 2012

After lots of playing around, I finally got this to work :)

rel='{"id":"#id#","name":"#replace(name,"'","&##39;","all")#"}'

Related questions

Coldfusion jQuery getJSON : Getting WDDX instead of JSON

I am using Brian Rinaldi's coldfusion function to convert a dotnet webservice dataset into a structure of queries. Each query is then returned to the client page as JSON to be used in a jQuery function. The queries are valid …

Read More
Convert array to JSON

I have an Array var cars = [2,3,..] which holds a few integers. I've added a few values to the array, but I now need to send this array to a page via jQuery's .get method. How can I convert it to …

Read More
Loading local JSON file

I'm trying to load a local JSON file but it won't work. Here is my JavaScript code (using jQuery): var json = $.getJSON("test.json"); var data = eval("(" +json.responseText + ")"); document.write(data["a"]); The test.json file: {"a" : "b", "c" : "…

Read More