> > 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. > > > alias your columns as a temporary workaround? > ie "select sysdate-1 as mydate from dual;" > I know oracle can do this , dunno about other databases.
This is a standard SQL-feature, that should work in any SQL-compliant database (at least I know it works in MSSQL and DB2 also). But I guess that the problem is that Johann lets the user enter SQL directly, loosing control of whats submitted to the DB. (which seems like a huge security risk, but I guess that this is adressed elsewhere in the application...) Johann - if you are brave ;) - you could use XSLT to parse the submitted SQL, and then extend the SELECT-clause with aliases? Askild - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
