Hi!
You can use another xsl or a generator to get this job done. For example,
using XSP:
<esql:connection>
<esql:pool>mp_pool</esql:pool>
<esql:execute-query>
<esql:query>
SELECT usr_id, usr_name, FROM users
WHERE usr_enable=1
</esql:query>
<esql:results>
<UsersList>
<esql:row-results>
<User>
<ID><esql:get-int column="usr_id"/></ID>
<Name><esql:get-string column="usr_name"/></Name>
</User>
</esql:row-results>
</UsersList>
</esql:results>
</esql:execute-query>
</esql:connection>
I hope this will help you. :-)
Antonio Gallardo
> Hi,
> When I execute a query like "select wfID as ID, wfName as Name from
> Workflowlist" In the browser (I used the default xml2html stylesheet) I
> get something like this :
>
> -<4="4"name="name">
> -<>
> <>1</>
> <>Max_pkg1</>
> </>
> -<>
> <>2</>
> <>Max_pkg2</>
> </>
> ...
> </>
>
> But how can I get the tags like :
>
> -<Workflowlist>
> -<Workflow>
> <ID>1</ID>
> <Name>Max_pkg1</Name>
> </Workflow>
> -<Workflow>
> <ID>2</ID>
> <Name>Max_pkg2</Name>
> </Workflow>
> ...
> </Workflowlist>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
