Ok on the tree the label field has to be the same name for all nodes, if you
take a look in the docs for labelField every example has the same field name
for the tree control.
you need to get your xml output looking like. The tree does not know how to
properly display arbitrary xml elements.
<Employee label="Lynn Tsoflias" otherinfo1="">
<SalesTerritory label="Australia" otherinfo1="">
<SalesPerson label="36" otherinfo1="">
</SalesPerson>
</SalesTerritory>
</Employee>
<Employee label="José Saraiva" otherinfo1="">
<SalesTerritory label="Canada" otherinfo1="">
<SalesPerson label="31" otherinfo1="">
</SalesPerson>
</SalesTerritory>
</Employee>
Use attributes and when the user selects get at the id's with the @label
type of call to the selected item
so [EMAIL PROTECTED] gives you your info for example.
or i think the tree is better user like this
private function labelFormater(curritem:XML):String{
return curritem.name();
}
<mx:Tree change="handleChange(event)" width="100%" height="250" id="xmltree"
labelFunction="labelFormater" dataProvider="{MyDS2}"></mx:Tree>
Then you display the element children in your list
private function handleChange(event:Event):void{
testtree.dataProvider = event.currentTarget.selectedItem;
}
<mx:DataGrid id="testtree" dataProvider="{rawXML.result.ROOT.row}"
height="300" />
Think of the tree as selecting sales people or territory then the grid as
people in that territory. Or some other variant like that.
Of course that all depends on what you goal is :)
In my tree's I never did it this way i have always used attributes for a
tree structure. So you have this or a label function but a label function
will still not give what you want, better off trying to get you format
eatable for flex.
It has to be the same value label for each node or a labelfunction.
In the case of the grid you can't as far as I know get at the nested
elements just using the dataField, it sure as heck would be handy though.
So your going to need to create a itemrenderer action script class. These
are well documented and you better to get your head around them asap.
extending components and building renderers I find are a big part of
developing in Flex.
sorry i could not be of more help
jason
-----Message d'origine-----
De : [email protected] [mailto:[EMAIL PROTECTED] la
part de David Terry
Envoyé : vendredi 31 mars 2006 23:17
À : [email protected]
Objet : RE: [flexcoders] Beyond Confused (Please Help)- Flex 2 Beta 2 -
HTTPService & XML
I tried compressing the entire project folder but I guess it was to big - it
got kicked back and it was under 1 MB - pfff. I am just sending the 2 MXML
and XML files. You should be able to add them to any project.
~David T.
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Jason Hawryluk
Sent: Friday, March 31, 2006 2:57 PM
To: [email protected]
Subject: RE: [flexcoders] Beyond Confused (Please Help)- Flex 2 Beta 2 -
HTTPService & XML
and the sample project
-----Message d'origine-----
De : [email protected] [mailto:[EMAIL PROTECTED] la
part de David Terry
Envoyé : vendredi 31 mars 2006 22:48
À : [email protected]
Objet : RE: [flexcoders] Beyond Confused (Please Help)- Flex 2 Beta 2 -
HTTPService & XML
Okay... This is what I'm trying to understand. So if my XML returns
'child' elements I can't use it in a DataGrid. I found using FOR XML RAW
handy for the DataGrid because I can get to all nested elements -
essentially it returns rows.
But what about the Tree control - it expects a hierarchical data right?
I'm getting some very strange results with the Tree control bound a
dataProvider of dataProvider="{MyDS}".
I'll attach a screenshot but I don't know if it will work.
~David T.
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Jason Hawryluk
Sent: Friday, March 31, 2006 2:22 PM
To: [email protected]
Subject: RE: [flexcoders] Beyond Confused (Please Help)- Flex 2 Beta 2 -
HTTPService & XML
Ya "Territory" that's one level deeper. In the grid I just tried to do
dataField="Element.childElement" as well it did not work, but it did not
explode either. I think your going to have to get your hands dirty with a
cellrenderer to do that in a grid.
Binding this to a form would be a synch but a datafield Im not sure if you
can.
Hopefully someone else will shed some light. It certainly would be handy to
be able to bind nested elements from multiple levels to a grid.
Jason
-----Message d'origine-----
De : [email protected] [mailto:[EMAIL PROTECTED] la
part de David Terry
Envoyé : vendredi 31 mars 2006 22:10
À : [email protected]
Objet : RE: [flexcoders] Beyond Confused (Please Help)- Flex 2 Beta 2 -
HTTPService & XML
Hi Jason,
I still don't see the Territory data. I'm using the following XML
Template...
<?xml version="1.0" encoding="UTF-8"?>
<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:query>
SELECT Employee.FirstName as FirstName, Employee.FirstName as label,
Employee.LastName as LastName, SalesTerritory.Name as Territory,
SalesPerson.TerritoryID as TerritoryID, SalesPerson.TerritoryID as
label,SalesPerson.SalesPersonID as SalesPersionID, SalesTerritory.Name as
label
FROM SalesPerson INNER JOIN
Employee ON SalesPerson.SalesPersonID = Employee.EmployeeID
INNER JOIN
SalesTerritory ON SalesPerson.TerritoryID =
SalesTerritory.TerritoryID
ORDER BY SalesTerritory.Name
FOR XML AUTO, ELEMENTS
</sql:query>
</ROOT>
The data is being returned like this...
<?xml version="1.0" encoding="UTF-8" ?>
- <ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
- <Employee>
<FirstName>Lynn</FirstName>
<label>Lynn</label>
<LastName>Tsoflias</LastName>
- <SalesTerritory>
<Territory>Australia</Territory>
<label>Australia</label>
- <SalesPerson>
<TerritoryID>9</TerritoryID>
<label>9</label>
<SalesPersionID>36</SalesPersionID>
</SalesPerson>
</SalesTerritory>
</Employee>
</ROOT>
Here is my code....
<?xml version="1.0" encoding="utf-8"?>
<mx:Canvas xmlns:mx="http://www.adobe.com/2006/mxml"; xmlns="*" width="100%"
height="100%"
creationComplete="rawXML.send();autoelementsXML.send()" >
<mx:HTTPService
id="rawXML" resultFormat="object"
url="http://localhost/advwrk/templates/raw.xml";
useProxy="false" showBusyCursor="true" />
<mx:HTTPService
id="autoelementsXML" resultFormat="e4x"
url="http://localhost/advwrk/templates/autoelements.xml";
useProxy="false" showBusyCursor="true" result="handleResults(event)"/>
<mx:Script>
<![CDATA[
private function handleResults(event:Event):void{
trace(event, "put break point here");
}
]]>
</mx:Script>
<mx:XMLListCollection id="MyDS"
source="{autoelementsXML.result..Employee}"/>
<mx:HBox x="10" y="10" width="100%" height="100%">
<mx:VBox>
<mx:Label text="FOR XML RAW"/>
<mx:DataGrid dataProvider="{rawXML.result.ROOT.row}" height="300">
<mx:columns>
<mx:DataGridColumn headerText="First Name" dataField="FirstName"/>
<mx:DataGridColumn headerText="Last Name" dataField="LastName"/>
<mx:DataGridColumn headerText="Territory" dataField="Territory"/>
</mx:columns>
</mx:DataGrid>
</mx:VBox>
<mx:VBox>
<mx:Label text="FOR XML AUTO, ELEMENTS"/>
<mx:DataGrid dataProvider="{MyDS}" height="300">
<mx:columns>
<mx:DataGridColumn headerText="First Name" dataField="FirstName"/>
<mx:DataGridColumn headerText="Last Name" dataField="LastName"/>
<mx:DataGridColumn headerText="Territory"
dataField="SalesTerritory.Territory"/>
</mx:columns>
</mx:DataGrid>
</mx:VBox>
</mx:HBox>
</mx:Canvas>
Thanks again,
~David T.
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Jason Hawryluk
Sent: Friday, March 31, 2006 1:24 PM
To: [email protected]
Subject: RE: [flexcoders] Beyond Confused (Please Help)- Flex 2 Beta 2 -
HTTPService & XML
resultFormat="object"
change to
resultFormat="e4x"
The services will convert your xml to object value pair trees if you don't
do this.
for a data grid your going to want the xmllist collection
example:
<mx:XMLListCollection id="MyDS" source="{rawXML..Employee}"/>
or
<mx:XMLListCollection id="MyDS" source="{rawXML.ROOT.Employee}"/>
your going to want the "FOR XML AUTO, ELEMENTS" if your getting your xml
this way.
so then your grid becomes
<mx:DataGrid dataProvider="{MyDS}">
<mx:columns>
<mx:DataGridColumn headerText="First Name" dataField="FirstName"/>
<mx:DataGridColumn headerText="Last Name" dataField="LastName"/>
<mx:DataGridColumn headerText="Territory" dataField="Territory"/>
</mx:columns>
</mx:DataGrid>
you may want to send the service results to a function so you can debug and
see that it's what you really want
private function handleResults(event:Event):void{
trace("put break point here");
}
so your servcie is changed to
<mx:HTTPService
id="rawXML" resultFormat="object"
url="http://localhost/advwrk/templates/raw.xml";
useProxy="false" showBusyCursor="true" result="handleResults(event)" />
If this does not get you started for the grid, post back here, and i'll give
you some more help. Once you learn this it's basicly the same for a tree.
Again if you have problems with that as well, post back.
hope this helps
Jason
-----Message d'origine-----
De : [email protected] [mailto:[EMAIL PROTECTED] la
part de David Terry
Envoyé : vendredi 31 mars 2006 21:19
À : [email protected]
Objet : [flexcoders] Beyond Confused (Please Help)- Flex 2 Beta 2 -
HTTPService & XML
Hello everyone,
First off, thank you for reading this post and helping me understand this
issue. I am new to ActionScript coding but Ive taken a very serious
interest in RIA development using Flex.
Okay on to my issue. I truly dont understand how Flex reads XML out of an
HTTPService. At times when trying to bind the data I only see [object
Object]. Other times I see what I need to display. So
For us newbies
how about we hack this out.
Im using SQLXML IIS with XML Templates to return my SQL data using the FOR
XML option in the select statement. SQLXML IIS allows me to access my SQL
Server via HTTP using various methods I decided to use XML Templates for
security issues.
XML Template Example
------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:query>
SELECT Employee.FirstName as FirstName, Employee.FirstName as label,
Employee.LastName as LastName, SalesTerritory.Name as Territory,
SalesPerson.TerritoryID as TerritoryID, SalesPerson.SalesPersonID as
SalesPersionID
FROM SalesPerson INNER JOIN
Employee ON SalesPerson.SalesPersonID = Employee.EmployeeID INNER JOIN
SalesTerritory ON SalesPerson.TerritoryID =
SalesTerritory.TerritoryID
ORDER BY SalesTerritory.Name
FOR XML AUTO, ELEMENTS
</sql:query>
</ROOT>
I assume we all know TSQL but here is a little refresher on the FOR XML
method. FOR XML returns XML from SQL Server in various formats.
FOR XML RAW - Returns
------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
- <ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<row FirstName="Lynn" label="Lynn" LastName="Tsoflias"
Territory="Australia" TerritoryID="9" SalesPersionID="36" />
<row FirstName="José" label="José" LastName="Saraiva" Territory="Canada"
TerritoryID="6" SalesPersionID="31" />
</ROOT>
FOR XML AUTO Returns
------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
- <ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
- <Employee FirstName="Lynn" label="Lynn" LastName="Tsoflias">
- <SalesTerritory Territory="Australia" label="Australia">
<SalesPerson TerritoryID="9" label="9" SalesPersionID="36" />
</SalesTerritory>
</Employee>
</ROOT>
FOR XML AUTO, ELEMENTS Returns
------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
- <ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql">
- <Employee>
<FirstName>Lynn</FirstName>
<label>Lynn</label>
<LastName>Tsoflias</LastName>
- <SalesTerritory>
<Territory>Australia</Territory>
<label>Australia</label>
- <SalesPerson>
<TerritoryID>9</TerritoryID>
<label>9</label>
<SalesPersionID>36</SalesPersionID>
</SalesPerson>
</SalesTerritory>
</Employee>
</ROOT>
Okay with that said here is what I am trying to do.
I want to databind a control (DataGrid and Tree in these examples) with the
results. Here is my Flex code.
<mx:HTTPService
id="rawXML" resultFormat="object"
url="http://localhost/advwrk/templates/raw.xml";
useProxy="false" showBusyCursor="true" />
<mx:DataGrid dataProvider="{rawXML.result}">
<mx:columns>
<mx:DataGridColumn headerText="First Name" dataField="FirstName"/>
<mx:DataGridColumn headerText="Last Name" dataField="LastName"/>
<mx:DataGridColumn headerText="Territory" dataField="Territory"/>
</mx:columns>
</mx:DataGrid>
Now
This fails (I dont see any results), but if I place the results in a
Text
<mx:Text text="{rawXML.result}"/>
I get [object Object]
If I change the code to <mx:Text text="{rawXML.result.ROOT}"/>
It still displays [object Object].
But, changing it to <mx:Text text="{rawXML.result.ROOT.root}"/> returns many
[object Object] values.
Using a dataProvider of dataProvider="{rawXML.result.ROOT.root}" in the
DataGrid returns the results I expect, but lets say I was using the FOR XML
AUTO, ELEMENTS data with the dataProvider of
dataProvider="{rawXML.result.ROOT.Employee}" I also get data, BUT I cant
get the Territory data. It seems I only have access to the Employee node of
the tree and not children nodes.
Hold on to that though
Lets try using a Tree control with the dataProvider set to
dataProvider="{rawXML.result.ROOT.Employee}" using the FOR XML AUTO,
ELEMENTS data.
<mx:Tree dataProvider="{rawXML.result.ROOT.Employee}" />
Now based on the examples Ive seen I should have seen a Tree that looks
kind of like
Employee
Territory
ID
BUT
It seems I have the same problem as the DataGrid and can only see the
Employee level of the XML.
I have no idea what I am doing wrong.
My Questions
---------------------------------
How does Flex handle XML?
Why doesnt Flex understand the XML?
Am I doing something wrong?
Do I need to convert the data into something?
Am I missing a step?
ANY help would be GREATLY appreciated.
Many thanks,
~David T.
--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com
YAHOO! GROUPS LINKS
Visit your group "flexcoders" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com
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/
