I have devised a database reporting system based on Ant and XSLT that produces
its reports in Excel format.
For non-technical reasons, I have chosen to store some information in XML files
rather than in the database itself. The list of strings that are part of the
SQL query could easily be stored in a table and be replaced with a sub-select
rather than using the XSLT-to-insert-literal-strings approach.
For that matter, the SQL queries now contained in XML elements could be moved
to stored procedures.
If I move to the approach outlined in this thread (further along the present
course), I have to wonder if I am building a more elaborate system than
necessary (and thereby creating unnecessary risk and maintenance expense)
rather than tackling the non-technical reasons directly.
So you see, the problem isn't the capabilites of XSLT, it's really a question
of, "Is this approach better than moving more of the system into the database
itself?"
There really isn't an answer to be found on the list. I have to weigh competing
concerns and draw conclusions based on my environment, rather than simply on
the basis of "Can this be done?"
Thanks.
--
Charles Knell
cknell(_at_)onebox(_dot_)com - email
-----Original Message-----
From: Michael Kay <mike(_at_)saxonica(_dot_)com>
Sent: Fri, 6 Jul 2007 14:44:37 +0100
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Subject: RE: RE: [xsl] Dealing with <![CDATA[]]> when it can't be avoided
I'm at the point of wondering if XSLT is the best approach
here. It's a helluva hammer, but is my problem really a nail?
You haven't really explained (a) what you want to do with this data, or (b)
why you're finding it difficult to do in XSLT. So far it all seems very
straightforward indeed.
Michael Kay
http://www.saxonica.com/
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--