RE: column headings in SQL as column-tag

Questions specific to Saxon are best asked on the saxon-help list at
SourceForge.

You will have to retrieve the results into a temporary tree, and then
transform it to get the column names that you want.

Michael Kay
http://www.saxonica.com/ 

> -----Original Message-----
> From: Ganesh Babu N [mailto:nbabuganesh@xxxxxxxxx] 
> Sent: 09 December 2008 04:28
> To: XSL
> Subject:  column headings in SQL as column-tag
> 
> Hai All,
> 
> I am working on the SQL extension of Saxon. for column-tag we 
> have give the literal value. Is there any way to get the 
> column headings in SQL as column-tag values.
> 
> Suppose:
> 
> Database: Name - Ganesh
>                 Designation - Manager
>                 Age - 32
> 
> 
> Required result.
> <root>
>   <row>
>      <name>Ganesh</name>
>      <designation>Manager</designation>
>      <age>32</age>
>   </row>
> </root>
> 
> Regards,
> Ganesh