Thanks, Paul! I'll work with this some, also! Rick
> -----Original Message----- > From: Paul Stewart [mailto:[email protected]] > Sent: Wednesday, February 04, 2009 10:54 AM > To: cf-talk > Subject: Re: This CFC function and jQuery Ajax stuff is killing me... > > > Just been reading Learning Jquery so hopefully this can get you on the > right track > > $(document.ready(function( ) { > > $.getJSON('cfcName.cfc?method=methodName',function(data) > { > $.each(data,function(structKey, structValue){var buildDate = > structValue['month'] + structValue['year'] ; }); > }); > > }); > > The 1st callback function (in $getJSON method) uses your cfcs returned > JSON (i.e. data). > > The 2nd callback function belonging to the $.each method has access to > the current iteration key/value pair of your json(struct). > > Have not tried it but if cfc access set to remote and returnformat = > json i think it should bear fruit > > Rick Faircloth wrote: > > Not to overly dramatic, but, I think my head really is > > about to explode. I know my blood pressure is sky high! > > I'm going to conquer this stuff or die trying! (Probably > > will kill me...) > > > > Anyway, I'm trying to return data from a method involving > > 2 queries of data and some random data via ajax. > > > > I'm in *over* my head... I can work with simple stuff, but > > these functions are getting complex. > > > > Here's what I'm setting up to return via <cfreturn ... />: > > > > <cfset structSchedule.message = "Success"> > > <cfset structSchedule.month = "#arguments.month#"> > > <cfset structSchedule.year = "#arguments.year#"> > > <cfset structSchedule.qGetSchedule = "#qGetSchedule#"> > > <cfset structSchedule.qGetDutyDates = "#qGetDutyDates#"> > > > > <cfreturn structSchedule /> > > > > I have no idea if that's how I should be trying to return all that data. > > > > Below is what I'm getting in the response tab of firebug: > > (formatted a little so it's easier to read) > > > > As you can see, I'm getting the data, but I can't figure out how to > > read it back on the calling page. Is this where "serializeJSON" comes in? > > I'm using "returnFormat='JSON'" to return and data. > > > > Advice? Suggestions? Clues? > > > > Rick > > > > PS - I just realized I'm missing a lot of data. I should have 4 rows of > > data in the "QGETSCHEDULE" section for each date in the "QGETDUTYDATES" > > section. > > But that's probably just how I've got the queries set up... > > > > > > {"MONTH":2.0, > > > > "QGETSCHEDULE": > > {"COLUMNS": > > ["DUTY_ID","DATE","AM_PM","AGENT_ID","POSITION","FIRST_NAME","LAST_NAME"], > > "DATA":[[1677,"February, 28 2009 00:00:00","am",18,"primary","Mary","Fail"], > > [1678,"February, 28 2009 > > 00:00:00","am",19,"alternate","Rebecca","Nottingham"], > > [1679,"February, 28 2009 > > 00:00:00","pm",20,"primary","Renea","Camper"], > > [1680,"February, 28 2009 > > 00:00:00","pm",21,"alternate","Verjuana","Underwood"]]}, > > > > "MESSAGE":"Success", > > "YEAR":2009.0, > > > > "QGETDUTYDATES": > > {"COLUMNS":["DATE"], > > "DATA":[["February, 01 2009 00:00:00"], > > ["February, 02 2009 00:00:00"], > > ["February, 03 2009 00:00:00"], > > ["February, 04 2009 00:00:00"], > > ["February, 05 2009 00:00:00"], > > ["February, 06 2009 00:00:00"], > > ["February, 07 2009 00:00:00"], > > ["February, 08 2009 00:00:00"], > > ["February, 09 2009 00:00:00"], > > ["February, 10 2009 00:00:00"], > > ["February, 11 2009 00:00:00"], > > ["February, 12 2009 00:00:00"], > > ["February, 13 2009 00:00:00"], > > ["February, 14 2009 00:00:00"], > > ["February, 15 2009 00:00:00"], > > ["February, 16 2009 00:00:00"], > > ["February, 17 2009 00:00:00"], > > ["February, 18 2009 00:00:00"], > > ["February, 19 2009 00:00:00"], > > ["February, 20 2009 00:00:00"], > > ["February, 21 2009 00:00:00"], > > ["February, 22 2009 00:00:00"], > > ["February, 23 2009 00:00:00"], > > ["February, 24 2009 00:00:00"], > > ["February, 25 2009 00:00:00"], > > ["February, 26 2009 00:00:00"], > > ["February, 27 2009 00:00:00"], > > ["February, 28 200900:00:00"]]}} > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
