I was working on an application that takes an xml document and transforms it into a simulated database query return. I made a minor typo and discovered something that I did not know was possible. Instead of putting the xmlText into the cell I actually put the whole xml node into the cell. For example:
TheQuery = QueryNew("col1, col2");
TheXML = XMLParse("c:\thexml.xml", false);
void = QueryAddRow(TheQuery , 1);
void = QuerySetCell(TheQuery , "col1", TheXML.rootNode.xmlChildren[i].subNode.xmlText);
void = QuerySetCell(TheQuery , "col2", TheXML.rootNode.xmlChildren[i].subNode);
In the example above the output would have the xmltext of the subNode in col1 and the entire subNode in col2.
I am not quite sure how or where to use this. However, knowing it is possible may be handy someday.
--Dave
Tuesday, December 19, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment