Subject: RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!! From: "Greg Johnson" <gjohnson@xxxxxxxxxxxx> Date: Fri, 8 Aug 2003 16:58:23 -0400 |
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: [xsl] 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: [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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] SQL SELECT statement in X, Américo Albuquerque | Thread | RE: RE: [xsl] SQL SELECT statement , cknell |
[xsl] Transforming using DOMSource , John . Coffie | Date | Re: [xsl] Transforming using DOMSou, Tim Meals |
Month |