RE: SQL SELECT statement in XSLT!!!!!!!!!!!!

yes, that's a good workaround.
Thanks for the tip.

-----Original Message-----
From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Américo
Albuquerque
Sent: Wednesday, August 06, 2003 7:49 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE:  SQL SELECT statement in XSLT!!!!!!!!!!!!


Hi.

> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
> Greg Johnson
> Sent: Wednesday, August 06, 2003 3:42 PM
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: RE:  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