Databases
StackOverflow2013
Postsdbo
POjson response contains \n \r
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjson response contains \n \r
    primarykey
    data
    text
    <p>I'm working with ASP.NET and jQuery on client side.</p> <p>I'm using <a href="http://json.codeplex.com/" rel="noreferrer">Json.NET</a> to serialize data from the DB on the server side and I'm sending it to the client when an Ajax request arrives.</p> <p>When I open FireBug, I see the following json:</p> <pre><code>{"d":"[\r\n {\r\n \"CategoryID\": 1,\r\n \"CategoryName\": \"a\",\r\n \"Description\": \"123\",\r\n \"CategoryType\": \"Personal\",\r\n \"Traits\": [\r\n {\r\n \"TraitID\": 1,\r\n \"TraitName\": \"a\",\r\n \"Description\": \"aaa\"\r\n },\r\n {\r\n \"TraitID\": 1,\r\n \"TraitName\": \"a\",\r\n \"Description\": \"aaa\"\r\n }\r\n ]\r\n },\r\n {\r\n \"CategoryID\": 1,\r\n \"CategoryName\": \"b\",\r\n \"Description\": \"bla bla\",\r\n \"CategoryType\": \"Professional\",\r\n \"Traits\": [\r\n {\r\n \"TraitID\": 1,\r\n \"TraitName\": \"a\",\r\n \"Description\": \"aaa\"\r\n },\r\n {\r\n \"TraitID\": 1,\r\n \"TraitName\": \"a\",\r\n \"Description\": \"aaa\"\r\n }\r\n ]\r\n },\r\n {\r\n \"CategoryID\": 1,\r\n \"CategoryName\": \"c\",\r\n \"Description\": \"123\",\r\n \"CategoryType\": \"Personal\",\r\n \"Traits\": [\r\n {\r\n \"TraitID\": 1,\r\n \"TraitName\": \"a\",\r\n \"Description\": \"aaa\"\r\n },\r\n {\r\n \"TraitID\": 1,\r\n \"TraitName\": \"a\",\r\n \"Description\": \"aaa\"\r\n }\r\n ]\r\n },\r\n {\r\n \"CategoryID\": 1,\r\n \"CategoryName\": \"d\",\r\n \"Description\": \"bla bla\",\r\n \"CategoryType\": \"Professional\",\r\n \"Traits\": [\r\n {\r\n \"TraitID\": 1,\r\n \"TraitName\": \"a\",\r\n \"Description\": \"aaa\"\r\n },\r\n {\r\n \"TraitID\": 1,\r\n \"TraitName\": \"a\",\r\n \"Description\": \"aaa\"\r\n }\r\n ]\r\n }\r\n]"} </code></pre> <p>My code from server side:</p> <pre><code> [WebMethod] public static string LoadRatingForm() { bll_Trait t1 = new bll_Trait(); t1.TraitID = 1; t1.TraitName = "a"; t1.Description = "aaa"; bll_Trait t2 = new bll_Trait(); t2.TraitID = 1; t2.TraitName = "a"; t2.Description = "aaa"; bll_Trait t3 = new bll_Trait(); t3.TraitID = 1; t3.TraitName = "a"; t3.Description = "aaa"; bll_Trait t4 = new bll_Trait(); t4.TraitID = 1; t4.TraitName = "a"; t4.Description = "aaa"; bll_Category c1 = new bll_Category(); c1.CategoryID = 1; c1.CategoryName = "a"; c1.CategoryType = "Personal"; c1.Description = "123"; c1.Traits.Add(t1); c1.Traits.Add(t2); bll_Category c2 = new bll_Category(); c2.CategoryID = 1; c2.CategoryName = "b"; c2.CategoryType = "Professional"; c2.Description = "bla bla"; c2.Traits.Add(t3); c2.Traits.Add(t4); bll_Category c3 = new bll_Category(); c3.CategoryID = 1; c3.CategoryName = "c"; c3.CategoryType = "Personal"; c3.Description = "123"; c3.Traits.Add(t1); c3.Traits.Add(t2); bll_Category c4 = new bll_Category(); c4.CategoryID = 1; c4.CategoryName = "d"; c4.CategoryType = "Professional"; c4.Description = "bla bla"; c4.Traits.Add(t3); c4.Traits.Add(t4); List&lt;bll_Category&gt; list = new List&lt;bll_Category&gt;(); list.Add(c1); list.Add(c2); list.Add(c3); list.Add(c4); return JsonConvert.SerializeObject(list, Formatting.Indented); } </code></pre> <p>My jQuery code:</p> <pre><code>$.ajax({ type: "POST", url: "MyProfile.aspx/LoadRatingForm", data: "{}", contentType: "application/json; charset=utf-8", dataType: "json", success: function (response) { var html; var categories = response.d; $.each(categories, function (i, category) { // create //while (category.CategoryType == "Professional") { // //} html += category.CategoryName + " "; }); dialog.append(html); }, error: function () { alert("ERROR"); } }); </code></pre> <p>The 'dialog' variable is a jQuery UI modal dialog and the $.ajax code is in the dialog's 'open' event handler...</p> <p>What should I do to make the serialization result in a "correct" json format without any '\n', '\r' and '\' ?</p> <p>Thanks in advance!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSash
    1. USSash
    plurals
    1. 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. POjson response contains \n \r
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POjson response contains \n \r
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POjson response contains \n \r
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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