XSQL nested CURSOR

From: skelum <skelum_at_hotmail.com>
Date: Mon, 24 Feb 2003 10:48:46 -0500
Message-ID: <P9r6a.34553$or1.345215@wagner.videotron.net>

I have the following query :

<?xml version="1.0"?>
<classement connection="demo" xmlns:xsql="urn:oracle-xsql">

<xsql:query row-element="PARTICIPANT"
  rowset-element = "PARTICIPANTS"
  tag-case = "lower"
  id-attribute = "">

  SELECT PARTICIPANTS.PRENOM AS PRENOM,
         PARTICIPANTS.NOM AS NOM,
  CURSOR (SELECT PREDICTIONS.EQUIPE_GAGNANTE AS TEAM,

          PREDICTIONS.NB_PARTIE AS NP
          FROM PREDICTIONS

   WHERE PARTICIPANTS.PERSONNE_ID = PREDICTIONS.PERSONNE_ID)    AS PRED
  FROM PARTICIPANTS </xsql:query>
</classement>

result :

 <?xml version="1.0" ?>
 <classement>

      <participants>
          <participant>


               <prenom>Frédéric</prenom>

               <nom>Fortin</nom>

               <pred>

                    <pred_row num="1">
                        <team>NJY</team>
                        <np>4</np>
                    </pred_row>
                    <pred_row num="2">

                        ...

    What can I do to remove the num attribute and the "_row" in the element name of my CURSOR ???

    TIA
    fortin.frederic.2 AT uqam DOT ca Received on Mon Feb 24 2003 - 09:48:46 CST