Hi all,
recently I ran into a problem with SQL Transformer. The column names returned from the database are used for naming the children of sql:row, but those names can be something like "count(distinct xxx)" or 'SYS$xxxx', which violates the wellformed conditions of the return document.
Is there any implementation of SQLTransformer that generates <column name="xxx"> instead of <xxx>, which would solve the problem? For predefined statements I can control the SQL that is passed to the transformer, but I run into big hassle when letting the user enter SQL directly.
Hi Johnny,
As far as I know, there is no such transformer;
but alternatively you could use xsp with esql, which is not far more complex, but offers an individual mapping from columns to xml-tag-names.
Alex
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
