Search jQuery

jQuery Forum

sean.rabo..

JQuery AJAX/JSON Issue

in Using jQuery • 12 years ago

I'm using AJAX to pull information out of a mysql database and load it onto a page seamlessly. Overall, I've have just about everything working fine except for one thing. If the text stored in the database contains certain characters (', &, etc.), my AJAX call failsr. The call returns readystate 4 with a status 200; however, it also generates a parsererror and thus the success function isn't called.

Does anyone have any suggestions as I'm lost?

Thanks in advance.

Replies(1)

Kevin B

Re: JQuery AJAX/JSON Issue

12 years ago

the json being returned is not valid. all double quotes must be escaped, and the json must follow correct format. for example, all strings must be wrapped in double quotes. single quotes wont cut it.

below is an example of valid json. note, strings are always double quoted and double quotes are escaped.

{
"numOfResults" : 2,
"results" : [
{
"name" : "foo",
"value" : "'single' quotes don't need to be escaped."
},
{
"name" : "bar",
"value" : "\"double\" quotes must be escaped."
}
]
}

you can validate your json at http://jsonlint.com

Edit: Extra commas will also cause the json to fail validation.

-- Kevin

------------------------------------------------
http://www.tentonaxe.com - jQuery Snippets and Tutorials

Top Reply

Response title

Attachments

jQuery Forum

JQuery AJAX/JSON Issue

Replies(1)

Re: JQuery AJAX/JSON Issue

Statistics

Tags

Actions