W3C home > Mailing lists > Public > www-xsl-fo@w3.org > November 2006

Parse SQL Statement using XSL

From: Gregory Jungels <gregory.jungels@infor.com>
Date: Thu, 2 Nov 2006 11:28:51 -0600
Message-ID: <B038CB64124E4542A043E15DA43054590146BAFF@uschwexcu2.ssainternal.net>
To: <www-xsl-fo@w3.org>
I have an XML file that contains a SQL Statement inside one of the tags.
I am using FO to 'document' this query XML file.  The problem is, the
SQL statement is not formatted very neat.  I would like to break or
parse it so the output would look something like:

 

SELECT

            A.COL1,

            A.COL2,

            A.COL3 as SOME_COLUMN,

            B.COL1 as B_COL_1,

            B.COL2 as B_COL_2

FROM

            FILE1 A

            FILE2 B

WHERE

            A.COL1 = B.COL1     AND

            A.COL2 = B.COL2

ORDER BY SOME_COLUMN

 

 
Received on Thursday, 2 November 2006 19:09:40 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Wednesday, 3 October 2007 16:06:14 GMT