The example is attached, along with the sample xml files I created to test it.
Your array exists at result.diffgram.PulseLoansToday. In the example I left the diffgram node out of my test xml. Basically, you assign the today and yesterday arrays to variables, iterate through the today items, get the matching yesterday item, build a combined item object, and add it to the combined dataProvider array, which is bound to the DataGrid DataProvider. Tracy -----Original Message----- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dave Sent: Thursday, April 28, 2005 6:24 PM To: flexcoders@yahoogroups.com Subject: [flexcoders] Re: Multiple dataProviders for 1 dataGrid?? OK. Let me backup. Below is a sample of the data returned (an array of objects?) from the WS with the date specified as 1/10/2005. The dataProvider for the datagrid is "{service1.PulseLoansToday.result.diffgram.PulseLoansToday.PulseLo ansToday}" Binding to the dataProvider as specified produces the desired results within the datagrid (using "CATEGORY", "TOTALBAL", etc. as the column names). Here's the rub; within the SAME datagrid, I need to display one column of TOTALBAL for the selected date(1/10/2005 in this case), and another column of TOTALBAL for yesterday's date (thisDate request is empty so default is previous day's date). Since I can only bind a datagrid to one dataProvider, I need a way to combine the results into a new dataProvider that I can bind to the datagrid. Thanks for your help, -Dave SAMPLE DATA RETURNED FROM WEB SERVICE <?xml version="1.0" encoding="UTF-8"?> <soap:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";> <soap:Body> <PulseLoansTodayResponse xmlns="http://srv-corp- sql/XmlWebServices/"> <PulseLoansTodayResult> <xs:schema xmlns:msdata="urn:schemas-microsoft-com:xml- msdata" xmlns:xs="http://www.w3.org/2001/XMLSchema"; xmlns="" id="PulseLoansToday"> <xs:element name="PulseLoansToday" msdata:IsDataSet="true";> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="PulseLoansToday"> <xs:complexType> <xs:sequence> <xs:element name="SCHEDDATE" type="xs:string" minOccurs="0"/> <xs:element name="CATEGORY" type="xs:string" minOccurs="0"/> <xs:element name="TOTALBAL" type="xs:decimal" minOccurs="0"/> <xs:element name="TOTALCNT" type="xs:decimal" minOccurs="0"/> <xs:element name="SORTBY" type="xs:int" minOccurs="0"/> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> <diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft- com:xml-diffgram-v1" xmlns:msdata="urn:schemas-microsoft-com:xml- msdata"> <PulseLoansToday xmlns=""> <PulseLoansToday diffgr:id="PulseLoansToday1" msdata:rowOrder="0";> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>1-NEW VEHICLE</CATEGORY> <TOTALBAL>61427820.1900</TOTALBAL> <TOTALCNT>3177</TOTALCNT> <SORTBY>1</SORTBY> </PulseLoansToday> <PulseLoansToday diffgr:id="PulseLoansToday2" msdata:rowOrder="1";> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>2-USED VEHICLE</CATEGORY> <TOTALBAL>51179669.7000</TOTALBAL> <TOTALCNT>4322</TOTALCNT> <SORTBY>2</SORTBY> </PulseLoansToday> <PulseLoansToday diffgr:id="PulseLoansToday3" msdata:rowOrder="2";> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>3-UNSECURED</CATEGORY> <TOTALBAL>997362.0700</TOTALBAL> <TOTALCNT>761</TOTALCNT> <SORTBY>3</SORTBY> </PulseLoansToday> <PulseLoansToday diffgr:id="PulseLoansToday4" msdata:rowOrder="3";> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>4-EQUITY MORTGAGES</CATEGORY> <TOTALBAL>11356456.8100</TOTALBAL> <TOTALCNT>545</TOTALCNT> <SORTBY>4</SORTBY> </PulseLoansToday> <PulseLoansToday diffgr:id="PulseLoansToday5" msdata:rowOrder="4";> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>5-HELOC FIXED</CATEGORY> <TOTALBAL>2665131.6800</TOTALBAL> <TOTALCNT>94</TOTALCNT> <SORTBY>5</SORTBY> </PulseLoansToday> <PulseLoansToday diffgr:id="PulseLoansToday6" msdata:rowOrder="5";> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>6-HELOC VARIABLE</CATEGORY> <TOTALBAL>1452584.3100</TOTALBAL> <TOTALCNT>152</TOTALCNT> <SORTBY>6</SORTBY> </PulseLoansToday> <PulseLoansToday diffgr:id="PulseLoansToday7" msdata:rowOrder="6";> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>7-FIXED</CATEGORY> <TOTALBAL>6617278.6300</TOTALBAL> <TOTALCNT>255</TOTALCNT> <SORTBY>7</SORTBY> </PulseLoansToday> </PulseLoansToday> </diffgr:diffgram> </PulseLoansTodayResult> </PulseLoansTodayResponse> </soap:Body> </soap:Envelope> --- In flexcoders@yahoogroups.com, "Tracy Spratt" <[EMAIL PROTECTED]> wrote: > Well, this is definitely on topic, so lets keep it here. Besides, > someone else might be able to help. > > An Object is NOT the same as an array of Objects, at least from a list > dataProvider standpoint. But there has to be an array in there > somewhere! Sometimes the array is at result[0], and not at result. > > What are you using to debug? Flex Builder? Can you examine the result > object? > Did you try the for loop? If you have an object, that might not work. > But it might with result[0]. > Also try: > for (var key in result){ > trace(key + ":" + result[key]); > } > > We can also try specifying the result to be in xml. > > We need to know exactly what our data looks like. > > Do the current results display in the datagrid? If so, how are you > specifying the dataProvider and the column sources? > > Tracy > > -----Original Message----- > From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On > Behalf Of Dave > Sent: Thursday, April 28, 2005 3:14 PM > To: flexcoders@yahoogroups.com > Subject: [flexcoders] Re: Multiple dataProviders for 1 dataGrid?? > > Thanks for helping on this - my butt is on the line! YES - the WS is > sending back result type of Object. > > You can respond to [EMAIL PROTECTED] if you prefer. > > > Thanks, > > -Dave > > --- In flexcoders@yahoogroups.com, "Tracy Spratt" <[EMAIL PROTECTED]> > wrote: > > What is your result type? Object(default), xml > (resultFormat="xml"). If > > you think it is an array of objects (the best case), then in your > result > > handler, run a test like this: > > > > for ( i:Number=0;i<result.length;i++){ > > trace(result[i].someObjectpropertyName) > > } > > Do you see what you expect? If so, I'll write a quick example > that will > > use two such arrays of objects to build a third suitable for a > > dataProvider. > > Tracy > > > > -----Original Message----- > > From: flexcoders@yahoogroups.com > [mailto:[EMAIL PROTECTED] On > > Behalf Of Dave > > Sent: Thursday, April 28, 2005 10:03 AM > > To: flexcoders@yahoogroups.com > > Subject: [flexcoders] Re: Multiple dataProviders for 1 dataGrid?? > > > > Sorry but I'm not very familiar with AS - can you give me an > example > > and/or pointers? > > > > Thanks, > > > > -Dave > > > > > > --- In flexcoders@yahoogroups.com, "Tracy Spratt" <[EMAIL PROTECTED]> > > wrote: > > > I think you will need to programmatically combine the two > results > > into a > > > new dataProvider. > > > > > > This is not difficult in AS, but the details depend on the > result > > type. > > > > > > Tracy > > > > > > -----Original Message----- > > > From: flexcoders@yahoogroups.com > > [mailto:[EMAIL PROTECTED] On > > > Behalf Of Dave > > > Sent: Tuesday, April 26, 2005 4:13 PM > > > To: flexcoders@yahoogroups.com > > > Subject: [flexcoders] Multiple dataProviders for 1 dataGrid?? > > > > > > > > > > > > Accessing a web service, in one dataGrid I have a column that > > displays > > > the account balance (TOTALBAL) per product.as of current date. > > Another > > > column in the same dataGrid displays the account balance > > (TOTALBAL) > > > but for the date 12/31/2004. I can't figure out a solution since > > > column names can't be identical. > > > > > > I duplicate the web service so that I have service1 and > service2 - > > > where I pass the 12/31/2004 date to service2. So TOTALBAL for > > service1 > > > corresponds with current day and TOTALBAL for service2 > corresponds > > > with 12/31/2004. > > > > > > Any ideas on how to render this data within the same dataGrid? > > Please > > > help ASAP. > > > > > > Thanks, > > > > > > -Dave > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<PulseLoansToday xmlns=""> <PulseLoansToday id="PulseLoansToday1" rowOrder="0"> <SCHEDDATE>01/09/2005</SCHEDDATE> <CATEGORY>1-NEW VEHICLE</CATEGORY> <TOTALBAL>1234567.1900</TOTALBAL> <TOTALCNT>3177</TOTALCNT> <SORTBY>1</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday2" rowOrder="1"> <SCHEDDATE>01/09/2005</SCHEDDATE> <CATEGORY>2-USED VEHICLE</CATEGORY> <TOTALBAL>23456578.7000</TOTALBAL> <TOTALCNT>4322</TOTALCNT> <SORTBY>2</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday3" rowOrder="2"> <SCHEDDATE>01/09/2005</SCHEDDATE> <CATEGORY>3-UNSECURED</CATEGORY> <TOTALBAL>345678.0700</TOTALBAL> <TOTALCNT>761</TOTALCNT> <SORTBY>3</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday4" rowOrder="3"> <SCHEDDATE>01/09/2005</SCHEDDATE> <CATEGORY>4-EQUITY MORTGAGES</CATEGORY> <TOTALBAL>56789.8100</TOTALBAL> <TOTALCNT>545</TOTALCNT> <SORTBY>4</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday5" rowOrder="4"> <SCHEDDATE>01/09/2005</SCHEDDATE> <CATEGORY>5-HELOC FIXED</CATEGORY> <TOTALBAL>98761.6800</TOTALBAL> <TOTALCNT>94</TOTALCNT> <SORTBY>5</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday6" rowOrder="5"> <SCHEDDATE>01/09/2005</SCHEDDATE> <CATEGORY>6-HELOC VARIABLE</CATEGORY> <TOTALBAL>333333.3100</TOTALBAL> <TOTALCNT>152</TOTALCNT> <SORTBY>6</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday7" rowOrder="6"> <SCHEDDATE>01/09/2005</SCHEDDATE> <CATEGORY>7-FIXED</CATEGORY> <TOTALBAL>454545.6300</TOTALBAL> <TOTALCNT>255</TOTALCNT> <SORTBY>7</SORTBY> </PulseLoansToday> </PulseLoansToday>
PulseLoansCombinedDP.mxml
Description: PulseLoansCombinedDP.mxml
<PulseLoansToday xmlns=""> <PulseLoansToday id="PulseLoansToday1" rowOrder="0"> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>1-NEW VEHICLE</CATEGORY> <TOTALBAL>61427820.1900</TOTALBAL> <TOTALCNT>3177</TOTALCNT> <SORTBY>1</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday2" rowOrder="1"> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>2-USED VEHICLE</CATEGORY> <TOTALBAL>51179669.7000</TOTALBAL> <TOTALCNT>4322</TOTALCNT> <SORTBY>2</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday3" rowOrder="2"> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>3-UNSECURED</CATEGORY> <TOTALBAL>997362.0700</TOTALBAL> <TOTALCNT>761</TOTALCNT> <SORTBY>3</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday4" rowOrder="3"> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>4-EQUITY MORTGAGES</CATEGORY> <TOTALBAL>11356456.8100</TOTALBAL> <TOTALCNT>545</TOTALCNT> <SORTBY>4</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday5" rowOrder="4"> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>5-HELOC FIXED</CATEGORY> <TOTALBAL>2665131.6800</TOTALBAL> <TOTALCNT>94</TOTALCNT> <SORTBY>5</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday6" rowOrder="5"> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>6-HELOC VARIABLE</CATEGORY> <TOTALBAL>1452584.3100</TOTALBAL> <TOTALCNT>152</TOTALCNT> <SORTBY>6</SORTBY> </PulseLoansToday> <PulseLoansToday id="PulseLoansToday7" rowOrder="6"> <SCHEDDATE>01/10/2005</SCHEDDATE> <CATEGORY>7-FIXED</CATEGORY> <TOTALBAL>6617278.6300</TOTALBAL> <TOTALCNT>255</TOTALCNT> <SORTBY>7</SORTBY> </PulseLoansToday> </PulseLoansToday>
