yes, that's a good workaround.
Thanks for the tip.
-----Original Message-----
From: owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
[mailto:owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com]On Behalf Of
Américo
Albuquerque
Sent: Wednesday, August 06, 2003 7:49 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!!
Hi.
-----Original Message-----
From: owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
[mailto:owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com] On Behalf Of
Greg Johnson
Sent: Wednesday, August 06, 2003 3:42 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!!
I've been working with MS SQL Server, and have been doing
joins in my SQL queries, and have been stuck with some
unintuitive element nesting, from MS's "For XML Auto,
Elements" switch.
You can use MSSQL to remove the nesting.
To do that you need to craete a view with you SQL with the inner joins
Then in you SQL with the "For XML Auto" you select from your view
This way your xml will not be nested but with a single element under the
root element
Hope this helps you
Regards,
Americo Albuquerque
(...)
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list