Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
COURSE of the MONTH
13 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
JSON Objects in ColdFusion
Posted on 2010-08-16
I have a partner that wants to send my CFC the following Array of Objects using JSON:
[
{
"fullName": "Joe Strummer",
"phoneNumber" : 2028586745,
"city" : "Washington, DC"
},
{
"fullName": "Mick Jones",
"phoneNumber" : 2029768143,
"city" : "Washington, DC"
},
{
"fullName": "Ian MacKaye",
"phoneNumber" : 2022675545,
"city" : "Washington, DC"
}
]
What's the best way to get this data into my database? I've read the following article:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_43.html#5176845 . It's helpful but it is calling the feed rather than another application calling MY cfc. How do access the data above so I can pass it to the deserializeJSON()?
[
{
"fullName": "Joe Strummer",
"phoneNumber" : 2028586745,
"city" : "Washington, DC"
},
{
"fullName": "Mick Jones",
"phoneNumber" : 2029768143,
"city" : "Washington, DC"
},
{
"fullName": "Ian MacKaye",
"phoneNumber" : 2022675545,
"city" : "Washington, DC"
}
]
What's the best way to get this data into my database? I've read the following article:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_43.html#5176845 . It's helpful but it is calling the feed rather than another application calling MY cfc. How do access the data above so I can pass it to the deserializeJSON()?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
Active 7 days ago
which database ?
For Oracle the following may help : http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/JSON/A_2715-Import-and-Export-datas-from-JSON-string-to-Oracle-with-Java-Stored-Procedure.html
For Oracle the following may help : http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/JSON/A_2715-Import-and-Export-datas-from-JSON-string-to-Oracle-with-Java-Stored-Procedure.html
leakim971,
Thanks for the link. I'm using mySQL. What I need help with is how to access the JSON data sent to my web service in ColdFusion.
Thanks for the link. I'm using mySQL. What I need help with is how to access the JSON data sent to my web service in ColdFusion.
Active 7 days ago
generaly you get a string and you unserialize it : http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_43.html
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
A frequently asked question goes something like this: "I am running a long process in the background and I want to alert my client when the process finishes. How can I send a message to the browser?" Unfortunately, the short answer…
- CSS
- HTML
- JavaScript
- PHP
- jQuery
- AJAX
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key.
We will concen…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in
size by cleaning up the database.
This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used.
Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to set up basic WordPress SEO.
This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast.
Go to your WordPress login page. This will look like the following: myw…
Suggested Courses
Course of the Month13 days, 8 hours left to enroll
801 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.