Would it not be better
and cleaner to modify the WS so you have all the data needed in one and only
one message?
Best regards.
J.
De:
[email protected] [mailto:[EMAIL PROTECTED] En nombre de Dave
Enviado el: Jueves, 28 de Abril de
2005 05:24 pm
Para: [email protected]
Asunto: [flexcoders] Re: Multiple
dataProviders for 1 dataGrid??
Importancia: Alta
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 [email protected], "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: [email protected]
[mailto:[EMAIL PROTECTED] On
> Behalf Of Dave
> Sent: Thursday, April 28, 2005 3:14 PM
> To: [email protected]
> 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 [email protected],
"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: [email protected]
> [mailto:[EMAIL PROTECTED] On
> > Behalf Of Dave
> > Sent: Thursday, April 28, 2005 10:03 AM
> > To: [email protected]
> > 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 [email protected],
"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: [email protected]
> > [mailto:[EMAIL PROTECTED] On
> > > Behalf Of Dave
> > > Sent: Tuesday, April 26, 2005 4:13
PM
> > > To: [email protected]
> > > 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
