data from OUTPUT=xml:ado

[skalyanaraman]

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!!

[John]

It looks as if there should be a new-line between each field. I'm not sure why that wouldn't be enough, but we'll need to check, as it has worked here. Do you know which version of ADO you are using?

[skalyanaraman]

I think it is my fault. we were doing a fetch and when we get the data back we have the xml string and the first thing we have is the texis copyright information. we are stripping it out and in the process we somehow change the xml file also.
There is no issue with the xml format. Forgive me.
But is there a way to avoid the texis copyright?
thanks!!

[John]

If you access the script as .../scriptname/function.xml (where function can be main for the default entry) you should get correctly formatted XML.

[skalyanaraman]

You are the best. I put scriptname/main.xml. WOrked like a charm, saved us lot of replace and mid, left, right code in VBScript.

Thanks!!