SAXONICA

Saxon Documentation
Full Contents
About Saxon
Changes in this Release
Conditions of Use
Using XSLT 2.0
Using XQuery
Handling Source Documents
XML Schema Processing
The XPath API
Standards Conformance
Extensibility
Saxon Extensions
Sample Saxon Applications
The Saxon SQL Extension
| Introduction
| sql:connect
| sql:query
» | sql:insert and sql:column
| sql:close
| Example
| A Warning about Side-Effects
XSLT Elements
XPath 2.0 Expression Syntax
Function Library
XSLT Patterns

# sql:insert and sql:column

`sql:insert` performs an SQL INSERT statement. This causes a row to be added to the table identified by the "table" attribute. There is a mandatory `connection` attribute, used as in the `sql:query` instruction described above.

`sql:column` is used as a child element of `sql:insert`, and identifies the name and value of a column to be included in the INSERT statement. The name of the column is identified by the `name` attribute, the value may be indicated either by evaluating the expression contained in the `select` attribute, or as the expanded contents of the `sql:column` element. The value is always interpreted as a String. (Remember this is purely a demonstration of extensibility, in a real system there would be a need to cater for SQL columns of other data types).

Next