Hi Ray, Unfortunately, CFSPRYDATASET does not allow you to set queryFormat=Colunmn, it is only by Row.
> Check out the blog entry I did on this: > > http://www.coldfusionjedi.com/index. cfm/2007/10> /3/Code-from-ColdFusion-Boot-Camp-and-Tip-about-ColdFusion-8-and-JSON > > On 10/4/07, Justin T <[EMAIL PROTECTED]> wrote: > > I have determined that the problem with cfsprydataset with JSON type > is that it fetches the CFC and sets the queryFormat (if you are > getting a query) to type row. > > > > This makes your JSON look like this: > > > > {"COLUMNS":["TITLE"],"DATA":[["The Tester"],[The Evil Man]]} > > > > Now, what options would you add so that SPRY would actually work > this out? > > > > To me it seem that there is no way for this to work unless they > change the default of the sprydataset tag to queryformat=column when > it calls the URL. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
