< How do you determine that something is a folder?
That is the question.
After transforming that XML I am getting an hierarchical XML - the one with 
folders.
So, my initial thought was to sort the result using a new column added by 
transformation.
That column could have 1 for a folder and 0 for a child.

"Martin Honnen" <mahotrash@y...> wrote in message 
news:e84VM6H2JHA.480@T......
> Markgoldin wrote:
>> Yes, you are right. Here it is:
>> <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
>> <VFPData>
>>  <tree menuid="91" parentid="24" name="Adam Briel" link=" " 
>> salesrepid="670" category="4" exclude="true" comments="true"/>
>>  <tree menuid="83" parentid="24" name="Betty Mazon" link=" " 
>> salesrepid="325" category="4" exclude="true" comments="true"/>
>>  <tree menuid="93" parentid="24" name="Christina Martinez" link=" " 
>> salesrepid="625" category="4" exclude="true" comments="true"/>
>>  <tree menuid="48" parentid="20" name="Current Inventory" salesrepid="0" 
>> category="4" exclude="true" comments="true"/>
>>  <tree menuid="67" parentid="20" name="Customer Details" salesrepid="0" 
>> category="4" exclude="true" comments="true"/>
>>  <tree menuid="61" parentid="20" name="Customer Order Status" 
>> link="http://ufd-sql2008test/ReportServer?%2fCustomerPoStatus&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno=&amp;SalesOrder=&amp;CustomerPO=&amp;Sku=&amp;OrderDate=&amp;ShipDateFrom=&amp;ShipDateTo= 
>> " salesrepid="0" category="4" exclude="true" comments="true"/>
>>  <tree menuid="24" parentid="20" name="Customer Reporting" salesrepid="0" 
>> category="4" exclude="true" comments="true"/>
>>  <tree menuid="20" parentid="1" name="Customer Service" salesrepid="0" 
>> category="4" exclude="true" comments="true"/>
>>  <tree menuid="62" parentid="20" name="Pick Plan Status" 
>> link="http://ufd-sql2008test/ReportServer?%2fPPStatus&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno= 
>> " salesrepid="0" category="4" exclude="true" comments="true"/>
>>  <tree menuid="50" parentid="48" name="Price Lists" salesrepid="0" 
>> category="4" exclude="true" comments="true"/>
>>  <tree menuid="55" parentid="20" name="Product LookUp" 
>> link="http://ufd-sql2008test/ReportServer?%2fCustserviceOpenOrders&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno= 
>> " salesrepid="0" category="4" exclude="true" comments="true"/>
>>  <tree menuid="47" parentid="48" name="Sku Attributes Reporting" 
>> link="http://ufd-sql2008test/ReportServer?%2fskuattributesFG&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ExcludeOnHand= 
>> " salesrepid="0" category="4" exclude="true" comments="true"/>
>>  <tree menuid="49" parentid="48" name="Sku Price List Preparation" 
>> salesrepid="0" category="4" exclude="true" comments="true"/>
>>  <tree menuid="95" parentid="24" name="Susan Finnane" link=" " 
>> salesrepid="375" category="4" exclude="true" comments="true"/>
>>  <tree menuid="1" name="United Feather and Down" salesrepid="0" 
>> category="0" exclude="true" comments="true"/>
>>  <tree menuid="90" parentid="24" name="Yoori Lee" link=" " 
>> salesrepid="650" category="4" exclude="true" comments="true"/>
>> </VFPData>
>>
>> Sure, I could add an extra column "folder". But how would I know in 
>> advance which node is a parent?
>
> So that is the XML, a flat list of 'tree' element nodes. How do you 
> determine that something is a folder? If the 'link' attribute value is an 
> empty string?
>
>
> -- 
>
> Martin Honnen --- MVP XML
> http://msmvps.com/blogs/martin_honnen/