Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Parse XML in Workbench Issue

Avatar

Level 4

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

1 Reply

Avatar

Level 4

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!