For XML Explicit

• Hatim Ali

  Old Hand

  Points: 375

  More actions

  July 25, 2004 at 11:49 pm

  #108752

  Hello,

  I need to get customized representation of XML. I know i can do this by using For XML Explicit. I've studied for XML Explicit documentation and figured out that i still cannot produce my desired XML.

  I need XML in the following format

  <object name="<name of table here">

    <property name="<name of column here>" value="<value of column here>"/>

    <property name="<name of column here>" value="<value of column here>"/>

    <property name="<name of column here>" value="<value of column here>"/>

  </object>

  The node object represents a single result row. I need the columns returned by the query to be the child of node "<object>" and each column should appear as a separate node called "<property>" with name and value attributes. 

  Is it possible using For XML Explicit.

  Any help will be greatly appreciated. Thanks in advance.

  Regards,

  Hatim Ali.

• fernando.pires@gustavsberg.com

  SSC Enthusiast

  Points: 106

  More actions

  July 27, 2004 at 5:18 am

  #516255

  How does your current code look like ?

  Why not use the XML bellow ?

  <object name="<name of table here">

    <property <name of column here>="<value of column here>"/>

    <property <name of column here>="<value of column here>"/>

    <property <name of column here>="<value of column here>"/>

  </object>

• Hatim Ali

  Old Hand

  Points: 375

  More actions

  July 27, 2004 at 5:59 am

  #516265

  Thanks for showing up fernando. Okay..  even how do i get these results which you have mentioned ??

  Regards,

  Hatim Ali.