MS SQL XML - Help with returning a well formed XML for 1 row using XDS

Author

Help with returning a well formed XML for 1 row using XDS

snandaca@gmail.com

2005-09-01, 8:24 pm

Hi,
I am trying to use SQLXML and have created the template file and schema
files. Everything works fine except that the XML returned is not well
formed i.e. it has the root tag but all the elements are all in one
row. I have tried the root=root option and it is not helping. I have
gone thru all newsgroups / googled it and I am running the latest
version of SQLXML 3.0 SP2 on a SQL2000 Server. It is running on Win XP
w/ SP2. Any help on how to resolve the problem would be appreciated!

Michael Rys [MSFT]

2005-09-02, 8:24 pm

Can you give a short example of the data you are getting and the one you
would like to get?

Thanks
Michael

<snandaca@gmail.com> wrote in message
news:1125614930.833716.88890@g14g2000cwa.googlegroups.com...
> Hi,
> I am trying to use SQLXML and have created the template file and schema
> files. Everything works fine except that the XML returned is not well
> formed i.e. it has the root tag but all the elements are all in one
> row. I have tried the root=root option and it is not helping. I have
> gone thru all newsgroups / googled it and I am running the latest
> version of SQLXML 3.0 SP2 on a SQL2000 Server. It is running on Win XP
> w/ SP2. Any help on how to resolve the problem would be appreciated!
>

Sponsored Links