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 |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] SQL SELECT statement in X, Greg Johnson | Thread | RE: [xsl] SQL SELECT statement in X, Greg Johnson |
RE: [xsl] very Simple nested for ea, Américo Albuquerque | Date | RE: [xsl] Contents of a <div> into , Américo Albuquerque |
Month |