Parse XML in Workbench Issue

[Former Community Member]

Running LC ES 8.2.1.3 on MS Server 2003 with MSSQL 2005 and JBoss

I have a stored procedure call that I have set up in workbench using the queryMultipleToXml service.  I am able to connect fine and can get the data into an XML type output variable called xmlOutput.  Below is the xml schema.

<Subordinates>

     <Subordinate>

          <full_name>Public, John</full_name>

          <id_nbr>123456</id_nbr>

          ....

     </Subordinate>

      <Subordinate>

          <full_name>Doe, Jane</full_name>

          <id_nbr>987654</id_nbr>

          ....

     </Subordinate>

     <Subordinate>

          <full_name>Doe, John</full_name>

          <id_nbr>654987</id_nbr>

          ....

     </Subordinate>

     <Subordinate>

          <full_name>Dandy, Jim</full_name>

          <id_nbr>123789</id_nbr>

          ....

     </Subordinate>

</Subordinates>

What I need to do in Designer is output all of the names into a drop-down list so that when the user selects a name it will populate the id number into a text field.

I am sure this is simple but I haven't been able to get this figured out.

Thank you in advance,

John

[Former Community Member]

I was able to get this parsed out correctly.  I stumbled upon this posting: http://forums.adobe.com/thread/439258.  I had to add a couple of things to mine but it worked perfect like they had it in that posting!

Thanks!