SQLEscapeXML
Guide to Escaping XML content for use with SQL insert
Release Notes
attachGoldenThread
cast
copy
cutGoldenThread
cwu
delete
dpml
dump
entrypoint
exists
expire
fls
guid
hotRestart
HTTPCookie
HTTPRedirect
isUnix
locationToXPath
lock/unlock
log
loglevel
luceneIndex
luceneSearch
mapper
mapper-export
md5
mls
netkernel:*
new
Orchextra
org.ten60.util.aspell
org.ten60.util.image.SVG2PNG
org.ten60.util.image.Text2PNG
org.ten60.util.image.xchart
plainTextToXHTML
regex
relativizeURI
requestWithArgs
resolveURI
serialize
sleep
sqlBatch
sqlBooleanQuery
SQLEncodeElement
SQLEscapeXML
sqlQuery
sqlUpdate
stm
stopWatch
StringToCanonicalString
throw
toRelaxNG
trace
validateDTD
validateRNG
validateSchematron
validateXSD
xacml
xform
XHREFlinker
XHTMLredirect
XHTMLTidy
xinclude
xmltidy
xpatheval
xpur
xquery
xrl
xsign
xslfo-fop
xslfo-fop
xslt
xverify
License
Change History
NetKernel History
Acknowledgements

SQLEscapeXML

An accessor to Escape XML to be suitable for SQL INSERT/UPDATE

Module

urn:org:ten60:netkernel:mod:db

Definition

Format

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

Syntax

ElementRulesDescription
typeMandatory SQLEscapeXML
operandMandatory the URI of the XML resources
targetMandatory Fragment OKtarget 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.


1060® NetKernelTM Documentation
(C) 2003-2004 1060 Research Limited

Send Feedback

© 2003,2004, 1060® Research Limited
1060 registered trademark, NetKernel trademark of 1060 Research Limited