0 Replies Latest reply: Feb 23, 2012 4:31 PM by user507131 RSS

    XSQL - Please help!

    user507131
      Hi,

      I'm a new bee to xsql and xsl. I have a xsql page which returns the following xml format. I'm creating a xsl file where I want to display the emp numbers in a drop down based on dept number.
      For example, For dept numver is 1, I want a dropdown with 100,200,300 as the values
      For dept numver is 2, I want a dropdown with 400,500,600 as the values

      Can someone provide me good suggestion. Thanks and I appreciate your feedback.


      <rowset num=1>
      <row num=1>
      <dept>1</dept>
      <deptType>IT <deptType>
      <emp>100</emp>
      </row>
      <row num=1>
      <dept>1</dept>
      <deptType>IT <deptType>
      <emp>200</emp>
      </row>
      <row num=1>
      <dept>1</dept>
      <deptType>IT <deptType>
      <emp>300</emp>
      </row>
      <row num=1>
      <dept>2</dept>
      <deptType>Marketing<deptType>
      <emp>400</emp>
      </row>
      <row num=1>
      <dept>2</dept>
      <deptType>Marketing<deptType>
      <emp>500</emp>
      </row>
      <row num=1>
      <dept>2</dept>
      <deptType>Marketing<deptType>
      <emp>600</emp>
      </row>
      </rowset>