[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!!


Subject: RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!!
From: Américo Albuquerque <melinor@xxxxxxx>
Date: Thu, 7 Aug 2003 00:49:04 +0100

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: [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



Current Thread
Keywords
xml