Solved

JSON serialization failure: Unable to serialize binary data to JSON

Posted on 2012-04-08
2
1,347 Views
Last Modified: 2012-04-08
I have a simple CFQUERY in a CFC which gets data from a mySQL table.  I'm using getJSON to load the data into my CFML page.  

My first attempt was wholly successful, but I have now added a new column into the mySQL query and after doing this, I now get an error: "JSON serialization failure: Unable to serialize binary data to JSON".

The new column I added to my CFQUERY is:
CONCAT(CASE WHEN H2HrefNo < 10 THEN '000' WHEN H2HrefNo < 100 THEN '00' WHEN H2HrefNo < 1000 THEN '0' ELSE '' END, H2HrefNo, '.jpg') AS filename,

All this is trying to do is to give a jpg file name in the format of something like: 0001.jpg, 0012.jpg, 0134.jpg,  etc -- forcing four digits regardless of actual H2HrefNo value (1 or 12 or 134 etc).

I've tried to see what is going wrong with Firebug but without success.  Any suggestions to fix my JSON serialisation failure would be appreciated.
0
Comment
Question by:ShanghaiD
  • 2
2 Comments
 

Author Comment

by:ShanghaiD
ID: 37820736
I've simplified my SQL for the new column as:
RIGHT(CONCAT('000', H2HrefNo, '.jpg'),8) AS filename,
which gives the same mySQL result as the earlier syntax, but this still gives me the same JSON serialization failure error.
0
 

Accepted Solution

by:
ShanghaiD earned 0 total points
ID: 37820740
I've found a solution by changing the SQL syntax to:
CAST(RIGHT(CONCAT('000', H2HrefNo, '.jpg'),8)  AS CHAR) AS filename,
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now