1 Reply Latest reply on Feb 16, 2007 7:38 AM by insuractive

    Generating XML out of database

      Is there any advice about how I should form my xml? I don't know the best way to form the question so I'll try to give an example.


      Supervisor | Worker | Job
      John , sarah , programmer
      John, bill, programmer
      Tom, Katie, office assistant

      Rather than have the xml returned:
      <row >
      <SUPERVISOR> John </SUPERVISOR> <WORKER> Sarah </WORKER> <JOB> programmer </JOB>

      I would like to receive:
      <supervisor name = "john">
      <worker name="sarah" job="programmer">
      <worker name="bill" job="programmer">

      I imagine this is a basic question but this is my first web/service xml application and I'm kind of at a loss in regards to where to start.