Databases
StackOverflow2013
Postsdbo
POunable to parse json data that includes a single quote
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POunable to parse json data that includes a single quote
    primarykey
    data
    text
    <p><strong>Problem</strong></p> <p>I'm getting a parse error on some of my json data, because it includes single quotes. For example, some of my data could look like this: </p> <p>"Larry's data"</p> <p>I've read the following article: <a href="https://stackoverflow.com/questions/2275359/jquery-single-quote-in-json-response">jQuery single quote in JSON response</a></p> <p>and I've been trying to implement some of the solutions but I haven't been able to get rid of my parse error. </p> <p><strong>Code</strong></p> <p>In my model, I'm using a lua library to encode my data as json. The model returns data that looks like this: </p> <pre><code>[{\"createddatetime\":\"2013-09-10 17:56:55\",\"description\":\"John Doe\'s phone\",\"number\":\"72051\",\"createdname\":\"conversion script\",\"user\":\"23123\",\"position\":\"46\",\"id\":\"49\",\"user_id\":\"822\",\"password\":\"rwer234\"}]" </code></pre> <p>In my view, my code currently looks like this: </p> <pre><code> $.ajax({ url:myurl + '?startpos=' + page_index * items_per_page + '&amp;numberofrecordstograb=' + items_per_page + '&amp;viewtype=json', success: function(data){ console.log('inside'); for(var i=0;i&lt;data.length;i++) { var deviceobj = data[i]; newcontent = newcontent + "&lt;TR&gt;"; newcontent=newcontent + '&lt;TD&gt;'; //add EDIT hyperlink if ($("#editdevicesettings").val() == "true") { var temp = $("#editlinkpath").val(); newcontent=newcontent + temp.replace("xxx",deviceobj["device_id"]) + '&amp;nbsp;&amp;nbsp;'; } //add DELETE hyperlink if ($("#deletedevice").val() == "true") { var temp = $("#deletelinkpath").val(); newcontent=newcontent + temp.replace("xxx",deviceobj["device_id"]); } newcontent=newcontent + '&lt;/TD&gt;'; newcontent=newcontent + '&lt;TD&gt;' + deviceobj["number"] +'&lt;/TD&gt;'; newcontent=newcontent + '&lt;&lt;TD&gt;' + deviceobj["user"] + '&lt;/TD&gt;'; newcontent=newcontent + '&lt;&lt;TD&gt;' + deviceobj["password"] + '&lt;/TD&gt;'; if (deviceobj["name"]) { newcontent=newcontent + '&lt;TD&gt;' + deviceobj["name"] + '&lt;/TD&gt;'; } else { newcontent=newcontent + '&lt;TD&gt;&amp;nbsp;&lt;/TD&gt;'; } newcontent=newcontent + '&lt;TD&gt;' + unescape(deviceobj["description"]) + '&lt;/TD&gt;'; newcontent = newcontent + "&lt;/TR&gt;"; }// end for // Replace old content with new content $('#Searchresult').html(newcontent); }//end if }, error: function(request, textStatus, errorThrown) { console.log(textStatus); console.log('========'); console.log(request); }, complete: function(request, textStatus) { //for additional info //alert(request.responseText); console.log(textStatus); } }); </code></pre> <p>But I still get the parse error on this particular record. </p> <p>Any suggestions would be appreciated. Thanks. </p> <p><strong>EDIT 1</strong></p> <p>I've changed my logic so that when it fails, it print out "request.responseText" into the console. Here's what it looks like: </p> <pre><code>"[{\"createddatetime\":\"2013-09-10 17:56:55\",\"description\":\"John Doe\'s phone\",\"number\":\"72051\",\"createdname\":\"conversion script\",\"user\":\"28567\",\"position\":\"46\",\"id\":\"49\",\"user_id\":\"822\",\"password\":\"rwer234\"}]" </code></pre> <p>The apostrophe is still escaped.</p> <p><strong>EDIT 2</strong></p> <p>Here's what my code looks like on the server side (aka. in the model): </p> <pre><code>get_device_records = function(ajaxdata) local results = list_devices(nil,false,ajaxdata.startpos, ajaxdata.numberofrecordstograb) return results.value end </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USdot
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POunable to parse json data that includes a single quote
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POunable to parse json data that includes a single quote
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI think your json data in not valid, http://jsonlint.com/
      singulars
      1. POunable to parse json data that includes a single quote
      1. USdefau1t
    2. COyeah. i've tried testing in jsonlint but all my json data fails. i don't know why. but the browser is able to parse everything... except the ones with single quotes in them. i'd like to know why my data fails in jsonlint.
      singulars
      1. POunable to parse json data that includes a single quote
      1. USdot
    3. COYou have `dataType: 'json'` so, don't need to parse it manually, `jQuery` will do it, it's (data) already parsed object, also `"` are escaped, it's should be uncapped.
      singulars
      1. POunable to parse json data that includes a single quote
      1. USThe Alpha
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload