Post reply

For XML Explicit

  • 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.

  • 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>

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply