Nope, but, it should be simple, right? <cfset str = toJSON.queryToJSON(yourquery)>. What have you tried?
On Tue, Nov 20, 2012 at 10:18 AM, Mo Lay <[email protected]> wrote: > > Thanks Ray i ll look at that, > Do you have any small examples where we use that tojson.cfc ? > > Molay > > > So to be clear, you are generating valid JSON, but the CF Dev server > > is > > prefixing it with XML that breaks it. You want to tell jQuery: "Hey > > dude, > > before you parse the JSON, we need to strip some stuff out." Luckily > > this > > is easy. > > > > See this blog post: > > http://www.raymondcamden.com/index. > > cfm/2011/11/8/Handling-JSON-with-prefixes-in-jQuery-and-jQueryUI > > > > In it, I talk about how to strip the // from a response. You can > > modify > > this code though to remove that entire XML block. > > > > > > On Tue, Nov 20, 2012 at 9:25 AM, Mo Lay <[email protected]> > > wrote: > > > > > > > > Hi Ray, > > > thanks mfor your quick reply. > > > > > > The error message i got was from my dev environement. so yes we have > > a > > > licence and a production server where we move our code once tested. > > Pleas , > > > let me know when you;re back as i critically need this peace of code > > on how > > > to convert my query data into json. > > > > > > Thanks > > > > > > > > > >I believe, stress believe, you are screwed. I don't think there is > > a way > > > to > > > >get rid of that unless you put in a 'real' license. > > > > > > > >You can, however, fix this in jQuery using $.ajax with the option > > to edit > > > >the JSON before hand. > > > > > > > >I've got a meeting in 10 minutes, if this doesn't make sense to you > > and no > > > >one else chimes in, I'll be back in 1.5 hours and can tell you > > exactly how > > > >to do it. In theory it adds code that will only matter on dev, but > > it will > > > >be like 4 lines of code so no big deal. (And obviously you can > > remove it > > > >before going to production.) > > > > > > > > > > > > > > > > > > > >> > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5979 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
