JSON: Unterminated String Literal Error

Posted March 2, 2007 at 7:21 AM

Tags: ColdFusion, Javascript / DHTML, AJAX

I was just fooling around with some JSON (JavaScript Object Notation) and kept this error whenever I tried to return a string value that contained line breaks:

"unterminated string literal"

I know what the error was (especially as FireFox's FireBug kicks sooo much butt with AJAX), but I couldn't understand how to get around it. Is it possible that JSON values cannot have line breaks? Then it hit me! Javascript line breaks are represented by the "\n" character, NOT an actual line break. Therefore, values such as:

"Libby was this really cute
trainer that I used to work
with."

... should actually be:

"Libby was this really cute\ntrainer that I used to work\nwith."

I was able to update my ColdFusion to JSON algorithm, specifically my StringToJSON() UDF to escape all the special characters:

 Launch code in new window » Download code as text file »

  • <!--- Return a string object. --->
  • <cfreturn (
  • """" &
  • ToString( ARGUMENTS.Data ).ReplaceAll(
  • "(['""\\\/\n\r\t]{1})",
  • "\\$1"
  • ) &
  • """"
  • ) />

Now, it works just fine. This AJAX and JSON stuff is very cool and much more fun once you get a better idea of how it is all working.

Download Code Snippet ZIP File

Post Comment  |  Ask Ben  |  Other Searches  |  Print Page




Learning ColdFusion 9 - ColdFusion 9 tutorials, samples, examples, demos

Reader Comments

Mar 2, 2007 at 8:27 AM // reply »
33 Comments

Hey Ben, I don't know if you've ever seen it or care for it, but there's a ColdFusion implementation of JSON called CFJSON that I'm now maintaining. You can see it at http://www.epiphantastic.com/cfjson/ . I'm actually planning to release an update today, I may actually have to include the fix you found for your own library!


Mar 2, 2007 at 9:02 AM // reply »
95 Comments

Yup, this a common workaround for almost any web app that contains text with line breaks. Thanks for posting your little code snippet.


Mar 2, 2007 at 9:23 AM // reply »
7,490 Comments

@Thomas,

I like what you have done. I don't quite translate everything the same way. For instance, my CF Query object becomes a simple array of objects; it does not keep the column-first style that CF does. I also don't pass record count and stuff.

But, I do like what you have done. I have some ideas that might help improve it (or maybe not - I am mostly new to AJAX stuff). I would like to clean up what I have and send it to you for review. I will shoot you an email or something later this weekend or next week.


Mar 2, 2007 at 10:08 AM // reply »
33 Comments

@Ben,

I saw the same need as you to have a query as an array instead of a structure, and there's actually an argument that can be passed to make it return it as an array. Not well documented, I admit...

I was about to release a new version, but after reading your post I did a few tests with special characters and ran into one problem when there were double quotes in a string. I just tracked down the problem and found a fix, but I'm a bit puzzled as to why CF is behaving as it is. I'll try to send you an email when I have a sec later to describe the problem, maybe you'll have a clue as to why things are so.


Mar 2, 2007 at 4:30 PM // reply »
2 Comments

Why aren't you using the standard 'jsStringFormat()' function?


Mar 2, 2007 at 5:59 PM // reply »
7,490 Comments

@Ed,

JSStringFormat() just escapes certain characters. JSON is much more complex. It converts entire ColdFusion objects to Javascript, not just strings.


Mar 2, 2007 at 7:52 PM // reply »
33 Comments

Hey Ben, if you downloaded CFJSON earlier today, I recommend that you download the latest version that I just put up. There were some serious bugs that were fixed. And if you have any suggestions I'd love to hear them.


Mar 2, 2007 at 9:01 PM // reply »
2 Comments

"JSStringFormat() just escapes certain characters."

That's exactly what I was referring to. You were getting errors because of carriage returns/line feeds. jsStringFormat() converts those to '\n'. If you use that function on string values, you don't have to roll your own regular expression. Thomas Messier's CFJSON component uses the jsStringFormat() function.


Mar 3, 2007 at 6:33 AM // reply »
9 Comments

This information at last that has returned me on the necessary way :)


Mar 3, 2007 at 9:39 AM // reply »
7,490 Comments

@Ed,

I apologize. You were completely right about JSStringFormat(). I was not familiar with this function and I see now what you are saying. I am going to implement this. Thanks for the tip.


Apr 16, 2007 at 1:19 PM // reply »
1 Comments

Very helpful, even to those of us not using ColdFusion. Thanks! That 'invalid label' solution also saved me a lot of headache earlier. Props.


Apr 16, 2007 at 1:20 PM // reply »
7,490 Comments

Heck yeah! It's all about people helping people :)


Apr 20, 2009 at 12:59 AM // reply »
1 Comments

any idea how to fix 'unterminated string literal' as I try to pass the value of some html tags into javascript function?


Apr 21, 2009 at 9:29 AM // reply »
7,490 Comments

@Brian,

You are not giving us anything to work with.


Aug 3, 2009 at 11:50 PM // reply »
1 Comments

I dont know anything about none of this stuff, but every time I go to tagged or something, it say the same error that everybody is talking about here... Does anybody mind explaining this stuff to me because its beginning to become a true pain the the rectum... lol...


Aug 5, 2009 at 8:49 AM // reply »
7,490 Comments

@Andre,

What do you mean "go to tagged"? What are you doing when you get this error?


Feb 5, 2010 at 9:06 PM // reply »
1 Comments

Sweet, it works. makes total sense.


Feb 17, 2010 at 7:47 PM // reply »
1 Comments

Man, I just wanted you to know that this little tidbit helped me after two hours of banging my head against the monitor, wondering why my ExtJS-provided widget wasn't correctly parsing the JSON that it received from the server...

...and, yes, Firebug *does* rock!


Feb 17, 2010 at 9:07 PM // reply »
7,490 Comments

@Lamont,

Firebug does rock! I can hardly imagine having to go develop without it again.


Feb 26, 2010 at 6:26 PM // reply »
3 Comments

Hi Ben,

Thank you for all your informative blogs.

I have the same issue trying to parse data from a query to json. I have tried everything and no luck.

Is there a place where I can download StringToJSON() udf?

Thanks


Feb 27, 2010 at 11:36 AM // reply »
7,490 Comments

@Mike,

Are you talking about a server-side UDF? What language are you using?


Mar 1, 2010 at 6:34 PM // reply »
3 Comments

Yes, I was talking about the server-side UDF.
I'm using ColdFusion. I figured it out, basically escaping all "funny" characters.

Thanks
Mike
PS I enjoy your blogs...


Mar 1, 2010 at 6:56 PM // reply »
7,490 Comments

@Mike,

You could just use CF8's serializeJSON().


Mar 1, 2010 at 6:58 PM // reply »
3 Comments

True, but this work for CF7 :(


Post Comment  |  Ask Ben

Recent Blog Comments
Mar 15, 2010 at 5:46 AM
Free Hotel Stay For Hal Helms' Real-World OOP Class
if you are searching restaurants in delhi then check out this blog and have a look on the best restaurants in delhi and order food here. Here is the list of restaurants in delhi where you can either ... read »
Mar 14, 2010 at 3:56 PM
Parsing CSV Values In To A ColdFusion Query
@Ben Nadel, Ben, you're right. I have embedded delimiters, which this function does not handle. I also need to specify the column headers, which yours does not handle. Decisions, decisions. ... read »
Mar 14, 2010 at 2:01 PM
Creating UI Elements With Low-Coupling And Conditional Event Handling
@Ryan, It's definitely an interesting approach. I'm used to binding to objects / elements that the idea of binding to an event object is a bit much to wrap my head around just yet. As far as the TH ... read »
Mar 14, 2010 at 10:08 AM
The Magic Of Thinking Big By David Schwartz (Thanks Clark Valberg!)
@Kamal, You can get it off of iTunes / Audible.com. ... read »
Mar 13, 2010 at 9:14 PM
The Magic Of Thinking Big By David Schwartz (Thanks Clark Valberg!)
Ben, COuld you plz tell me how to find the audio book version of The Magic of Thinking Big by David J. Schwartz, Ph.D Thanks ... read »
sun
Mar 13, 2010 at 6:21 PM
Sending (SMS) Picture Messages With ColdFusion And CFMail
MY BAD! @tmomail.net IS correct ... but, ONLY from pic taken W/ a cell -- NOT as attachment in an email ... (took ~4 min. for it to arrive ... then would NOT DL to my cell) ... read »
sun
Mar 13, 2010 at 6:16 PM
Sending (SMS) Picture Messages With ColdFusion And CFMail
@tmomail.net is NOT correct! IS t-mobile addy ... but, ONLY for a txt msg! ... read »
Mar 12, 2010 at 8:24 PM
Creating UI Elements With Low-Coupling And Conditional Event Handling
@Ben, Yes, that's exactly what's happening. That's the approach YUI has taken with custom events, you subscribe the handler to the Event object itself. I really like the event system in YUI, it's ... read »