Re: cfquery to json array
toJson is better if you have room for the server-side overhead, and don't mind writing methods that can't be used in any other scenario than via Ajax. CFQueryReader is solely a client side solution, so that you can reuse your server-side code in any way that you see fit. Steve "Cutter" Blades Adobe Community Professional - ColdFusion Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Richard White wrote: > in fact toJson is even better for th job: http://tojson.riaforge.org/ > > >> thanks, sorry dont think i was clear enough, i knew about >> serializejson but this doesnt work with extjs, in case anyone else >> stumbles on this post and is interested i found the following: >> http://blog.cutterscrossing.com/index.cfm/CFQueryReader >> >> >>> Google is your friend: >>> >>> Search "cfquery to json" and get: >>> >>> http://www.coldfusionjedi.com/index. >>> >> cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example >> >>> >>> > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquery to json array
in fact toJson is even better for th job: http://tojson.riaforge.org/ > thanks, sorry dont think i was clear enough, i knew about > serializejson but this doesnt work with extjs, in case anyone else > stumbles on this post and is interested i found the following: > http://blog.cutterscrossing.com/index.cfm/CFQueryReader > > >Google is your friend: > > > >Search "cfquery to json" and get: > > > >http://www.coldfusionjedi.com/index. > cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example > > > > > > > >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquery to json array
thanks, sorry dont think i was clear enough, i knew about serializejson but this doesnt work with extjs, in case anyone else stumbles on this post and is interested i found the following: http://blog.cutterscrossing.com/index.cfm/CFQueryReader >Google is your friend: > >Search "cfquery to json" and get: > >http://www.coldfusionjedi.com/index.cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example > > > >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquery to json array
Google is your friend: Search "cfquery to json" and get: http://www.coldfusionjedi.com/index.cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example On Mon, Jun 7, 2010 at 11:53 AM, Richard White wrote: > > hi, > > is there a quick and easy way to convert a cfquery into a json array. i > will be returning the json array to extjs to present in a grid > > thanks > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm