OUTPUT=xml

[dpacke0]

In the vortex manual OUTPUT=xml explains that "Each field will be an element, named the same as the Vortex variable would be, nested in a result element within a results top-level element."

When I do:
<SQL NOVARS OUTPUT=xml "select VAR1 from ABC"></SQL>
where is the output?
I've tried:
<loop $VAR1> $VAR1 </loop>
<loop $ret> $ret </loop>
<loop $xml> $xml </loop>
all three are empty. How do I display the results of the SQL search?

Thanks.

[John]

The output will appear automatically from the SQL statement. Which version of texis do you have? The OUTPUT=xml as added more recently than the OUTPUT=xml:ado, and if your version is not new enough you won't see the output.

[dpacke0]

You found the problem -- my version is too old -- June 22, 2000.

Thanks.

[dpacke]

I tried OUTPUT=xml on a 12/18/2001 version and it worked great!