This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: The most important question and the reason why we are all here
| > Some columns may contain NULL. [how] do I test for NULL character since
| > it isn't a valid character in XML world?
|
| well how does the character appear in the XML version of your SQL query
| result? It must be encoded a XML somehow.
|
If you're using the Oracle XML SQL Utility, then by
default NULL columns are *left out* of the result.
You can call the method setNullIndicator(true) to
have it *instead* emit
<SOMETHING NULL="Y"/>
as opposed to *not* emitting an element for the SOMETHING column.
Other SQL-to-XML layers may have similar settings to check.
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
Business Components for Java Dev't Team, Oracle Corporation
| > Some columns may contain NULL. [how] do I test for NULL character since
| > it isn't a valid character in XML world?
|
| well how does the character appear in the XML version of your SQL query
| result? It must be encoded a XML somehow.
|
| David
|
|
| XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list