xsl and sql

[Kermit Tensmeyer]

[posted from bogus email address]

I've been trying to figure how to use the sql extensions (EXSLT) with regards to the various processors (saxon, xalan, xmlstarlet/xsltproc).

I've seen one example of inserting into a DBS, and one example of "select
* from Table" Are there other examples "out there?"

Is there a way to execute nested selects? Joined selects? selects with parameter placeholders? Sometimes it's easier to start with example code before undertaking major undertakings...

Kermit Tensmeyer

 

[Gregory Vaughan]

Hi,

You might take a look at ODBC2XML as an alternative. It allows SQL statements to be placed in an XML template as processing instructions (PIs), then simply expands the template with the query data. It handles nested and joined selects, and the Java version has a capability for parameter placeholders.

More information at http://www.intsysr.com/odbc2xml.htm

 

[Mikhail Grouchinsky]

[posted from bogus email address]

I've been trying to figure how to use the sql extensions (EXSLT) with regards to the various processors (saxon, xalan, xmlstarlet/xsltproc).

I've seen one example of inserting into a DBS, and one example of "select
* from Table" Are there other examples "out there?"

Is there a way to execute nested selects? Joined selects? selects with parameter placeholders? Sometimes it's easier to start with example code before undertaking major undertakings...

Kermit Tensmeyer

Take a look at Oracle XSQL. This is might be what you are looking for...