6 Replies Latest reply on Aug 22, 2013 10:14 AM by Moses Arockiadass

    How to read the column entries from SQL output?

      When I execute this command i get the output in a XML format.

       

      blcli_execute Sql executeSqlCommand "select top 1 name, description from bluser"

       

      Output:

       

      <ResultSet numberOfRows="1">

              <Row1 numberOfColumns="2">

                      <Table name="bluser">

                              <Column1>

                                      <Type>java.lang.String</Type>

                                      <Value>RBACAdmin</Value>

                                      <Name>name</Name>

                              </Column1>

                              <Column2>

                                      <Type>java.lang.String</Type>

                                      <Value>RBAC Administrator</Value>

                                      <Name>description</Name>

                              </Column2>

                      </Table>

              </Row1>

      </ResultSet>

      bladelogic%

       

       

      BBSA Version 8.2.01.328

       

       

      Thanks.