[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Todays technical challenge

Subject: Re: Todays technical challenge
From: "Andrew Welch" <andrew.j.welch@xxxxxxxxx>
Date: Wed, 13 Jun 2007 10:55:23 +0100
Re:  Todays technical challenge
On 6/13/07, Matt <puskas.duck@xxxxxxxxx> wrote:
Must admit I'm enjoying my first XSL project - my report is almost
complete, until a googly is thrown down! (Cricket term!)

In the report I produce there are a variable number of pages,
depending on overflows ie. if there are more than 30 transactions, a
new page is spawned. This page number it turns out is very important
as its used as the starting point for the next time a report is
produced.

So what I need to be able to do is take the final page number from XSL
template ( $pageNo parameter) and update my Oracle database table with
this value.

From experience I'd rather avoid using file system upload/downloads -
is there anyway I can create a function (unix shell, java etc..) which
can do this update.

Probably the most straightforward approach is to reparse the result XML after its been serialized and count the pages using an XMLFilter, an XPath or another transform.

Alternatively you could try Saxon's SQL entension:

http://www.saxonica.com/documentation/sql-extension/intro.html

There are other more involved ways if either of these aren't sufficient...

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.