ResultSetToXMLResultSetToXML
Converts a SQL resultset to XML
Home > Books > NetKernel API and Services Reference > Transreptor Listing > ResultSetToXML

Rate this page:
Really useful
Satisfactory
Not helpful
Confusing
Incorrect
Unsure
Extra comments:


Module

urn:org:ten60:netkernel:mod:db

Class

org.ten60.netkernel.rdbms.transreptor.ResultSetToXMLTransreptor

Purpose

Takes a com.ten60.netkernel.urii.aspect.IAspectResultSet and converts it to both unparsed XML com.ten60.netkernel.urii.aspect.IAspectString and DOM parsed XML com.ten60.netkernel.xml.representation.IXAspect.

A document is created with root node <results>. Each row of the result set is a first child element <row>. Each column value will be returned as an element with a text value of the result. It is important that the column names returned in the result set are valid XML element names - if they not then you can use the AS keyword in you queries to rename the returned column names.

If there are no results a canonical null <null/> document is returned.

© 2003-2007, 1060 Research Limited. 1060 registered trademark, NetKernel trademark of 1060 Research Limited.