XSL Property

ADO and SQL Server

ADO and SQL Server

XSL Property

The XSL property specifies an XSL file name or URL applied to the result of a query.

Applies To
Command Object
Syntax

object.Properties("XSL") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

String that specifies the file name or URL.

Data Type

adBSTR

Modifiable

Read/write

OLE DB Property

SSPROP_STREAM_XSL

Remarks

Relative paths are resolved by the Base Path property. If the Base Path property is not set, the relative path defaults to the current directory.

Output from command execution is expected to be a valid XML document (for example, SELECT FOR XML queries, templates, and XPath queries).

By definition, XSL takes two XML documents and produces a third. One of the input documents contains the data, and the other contains the XSL processing instructions.

Unless specified in the XSL document, the output document has a default encoding of UTF-8. If another encoding is required, it should be specified in the XSL document.

If the Output Encoding property is specified and an XSL document is also specified by the XSL property, the encoding specified in Output Encoding overrides the encoding of the XSL document.

See Also

Base Path Property

Content Type Property

Mapping Schema Property

SS STREAM FLAGS Property

URL Access

XML Root Property