Thunderstone Support Forums

Thanks that worked.

Now the only problem that I have is that of providing term highlighting on the xml format. You have suggested using <capture> sql statement capture </capture> then a $ret is available for formatting. Unfortunately the xml schema format is corrupted in that the <,>,and " symbols are converted to &lt, &gt , and &quot. Doing a replace on these would unfortunately remove &lt and &gt from the xml data section where it is needed.
Any ideas?

If you're going to be doing query highlighting in Vortex, then you want to display it in Vortex too; it's much easier (and runs faster) to use the normal column variables returned from <SQL> with <fmtcp> for highlighting, than to <SQL output=xml:ado>, capture it, and parse it multiple times for escapement/unescapement and hit markup. In other words, if you're outputting XML data, its receiver is responsible for its display formatting; if it can't do query highlighting and escapement, then let Vortex display it.

If you really need XML output with hit markup and escapement, then print the XML tags directly yourself, with the normal <SQL> column variables (eg. without OUTPUT=xml:ado) so that the XML data can be marked up and escaped as needed.

Looks like that would be the best way...

The issue was resolved with <send $ret> , the proper escapments were respected.

The term highlighting is essential so I will have to script it with standard output.

Thanks for the help

Hi,
I am right now doing an Integration package for Vignette. If you are interested please contact me carsten.harnisch1@epost.de.