SQLEscapeXML

Index > Books > Declarative Development Guide > Reference Library > Accessor Listing > SQLEscapeXML

Module

urn:org:ten60:netkernel:mod:db

Definition

Active URI Base

active:SQLEscapeXML

Format

<instr>
  <type>SQLEscapeXML</type>
  <operand>var:myxml</operand>
  <target>var:escaped</target>
</instr>

Syntax

Argument	Rules	Description
type	Mandatory	SQLEscapeXML
operand	Mandatory	the URI of the XML resources
target	Mandatory Fragment OK	target resource

The SQLEscapeXML accessor is used to escape all text elements in the operand XML document so that the text may be used in an SQL statement.

SQL parsers require apostrophe " ' " characters to be escaped to double apostrophes " '' ". This accessor escapes all text nodes (attributes and elements) in an XML document so that the text values may be used (substituted into) an SQL statement.