Page 1 of 1

data from OUTPUT=xml:ado

Posted: Fri Jul 27, 2001 5:17 pm
by 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!!

data from OUTPUT=xml:ado

Posted: Fri Jul 27, 2001 6:13 pm
by 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!!

data from OUTPUT=xml:ado

Posted: Fri Jul 27, 2001 6:51 pm
by 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!!