This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Xalan ODBC extension - implementation
- From: Peter dot FLYNN at syntegra dot com
- To: xsl-list at lists dot mulberrytech dot com
- Date: Tue, 22 Jan 2002 13:31:46 -0000
- Subject: RE: [xsl] Xalan ODBC extension - implementation
- Reply-to: xsl-list at lists dot mulberrytech dot com
One solution for building the XML representation of the result set is to
use the meta data returned to form the element names by using the
column names.
So in your example, the returned XML would be:
<RECORD>
<FRED>test1</FRED>
<JOE>test2</JOE>
</RECORD>
The hardest part is that the result set may not just return strings, but
you can check for this and create the appropriate XML element.
This is what we do inside out JDBC processing system and it
works quite well.
Regards,
Peter Flynn
********************************************************************
This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person
Thank you
Check us out at http://www.syntegra.com
********************************************************************
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list