data from OUTPUT=xml:ado
Posted: Fri Jul 27, 2001 5:17 pm
Hi,
We are using OUTPUT=xml:ado in our sql statement to get the xml output. The output looks fine in xml format, but there seems to be a small problem with the way the <z:row> tags are written out. They lack a space between each attribute (which is nothing but the fields from the table). For example,
<z:row DOCID="test"
DOCVALUE="Testing">
There is not space between DOCID=test" and DOCVALUE. When I do a rs.open in ado I get an erros if there is no space. For example, it is expecting something like this,
<z:row DOCID="test"
DOCVALUE="Testing">
Is there something I am doing wrong here? Any suggestions.
Thanks!!
We are using OUTPUT=xml:ado in our sql statement to get the xml output. The output looks fine in xml format, but there seems to be a small problem with the way the <z:row> tags are written out. They lack a space between each attribute (which is nothing but the fields from the table). For example,
<z:row DOCID="test"
DOCVALUE="Testing">
There is not space between DOCID=test" and DOCVALUE. When I do a rs.open in ado I get an erros if there is no space. For example, it is expecting something like this,
<z:row DOCID="test"
DOCVALUE="Testing">
Is there something I am doing wrong here? Any suggestions.
Thanks!!