node list problem

I have a xml file structure as follows...

<JOB_APPLICATIONS_FROM_WEB>
   <application>
      <vacancy_id>AN123/05</vacancy_id>
      <applicant_id>WA00315</applicant_id>
      <source_name>W</source_name>
      <acc_employee>F</acc_employee>
      <initials>A</initials>
      <surname>Yurkov</surname>
        ....
      <equal_opportunities>
         <eq_opps>
            <date_of_birth_DD>21</date_of_birth_DD>
            <date_of_birth_MM>Jun</date_of_birth_MM>
            <date_of_birth_YYYY>1976</date_of_birth_YYYY>
               ...
         </eq_opps>
      </equal_opportunities>
      <references>
         <reference>
            <ref_title>MRS</ref_title>
            <ref_forename>Jenny</ref_forename>
            <ref_surname>McHugh</ref_surname>
            <ref_check>F</ref_check>
         </reference>
      </references>
   </application>
   <application>
      <vacancy_id>AC358/05</vacancy_id>
      <applicant_id>WA08340</applicant_id>
      <source_name>W</source_name>
      <acc_employee>F</acc_employee>
      ....
</JOB_APPLICATIONS_FROM_WEB

I want to change the above structure to look like the following...

<JOB_APPLICATIONS_FROM_WEB>
   <application>
      <vacancy_id>AN123/05</vacancy_id>
      <applicant_id>WA00315</applicant_id>
      <source_name>W</source_name>
      <acc_employee>F</acc_employee>
      <initials>A</initials>
      <surname>Yurkov</surname>
        ....
      <equal_opportunities>
         <eq_opps>
            <vacancy_id>AN123/05</vacancy_id>
            <applicant_id>WA00315</applicant_id>
            <date_of_birth_DD>21</date_of_birth_DD>
            <date_of_birth_MM>Jun</date_of_birth_MM>
            <date_of_birth_YYYY>1976</date_of_birth_YYYY>
               ...
         </eq_opps>
      </equal_opportunities>
      <references>
         <reference>
            <vacancy_id>AN123/05</vacancy_id>
            <applicant_id>WA00315</applicant_id>
            <ref_title>MRS</ref_title>
            <ref_forename>Jenny</ref_forename>
            <ref_surname>McHugh</ref_surname>
            <ref_check>F</ref_check>
         </reference>
      </references>
   </application>
   <application>
      <vacancy_id>AC358/05</vacancy_id>
      <applicant_id>WA08340</applicant_id>
      <source_name>W</source_name>
      <acc_employee>F</acc_employee>
      ....
</JOB_APPLICATIONS_FROM_WEB

I want to take the vacancy_id and applicant_id fields and insert them
again under eq_opps and reference.

I have tried various things but always get the same value from the very
first record.

I've tried doing...

<xsl:variable name="v_vid" select="//application/@vacancy_id"/>

to give me a node list, but I'm not sure how to iterate around them.

Another option...

<xsl:template match="eq_opps">
      <xsl:copy>
            <vacancy_id><xsl:value-of
select="//application/@vacancy_id"/></vacancy_id>


I'm using XSLT version1.

The following code I'm using in Oracle 8 and works ok but does not work
in Oracle 9.

    <xsl:template match="application">
      <xsl:variable name="vid" select="@vacancy_id"/>
      <xsl:variable name="appid" select="@applicant_id"/>
        <xsl:copy>
        <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
  </xsl:template>
   <xsl:template match="eq_opps">
     <xsl:copy>
       <vacancy_id><xsl:value-of select="$vid"/></vacancy_id>
       <applicant_id><xsl:value-of select="$appid"/></applicant_id>
         <xsl:apply-templates select="@*|node()"/>
     </xsl:copy>
   </xsl:template>


Any suggestions?

   


Elaine Stewart
System Analyst
Finance & ICT Services
Telephone: 01224 523608

Elaine Stewart
System Analyst
Finance & ICT Services
Telephone: 01224 523608


IMPORTANT NOTICE: This e-mail (including any attachment to it) is confidential, 
protected by copyright and may be privileged.  The information contained in it 
should be used for its intended purposes only.  If you receive this e-mail in 
error, notify the sender by reply e-mail, delete the received e-mail and do not 
make use of, disclose or copy it. Whilst we take reasonable precautions to 
ensure that our emails are free from viruses, we cannot be responsible for any 
viruses transmitted with this e-mail and recommend that you subject any 
incoming e-mail to your own virus checking procedures.  Unless related to 
Council business, the opinions expressed in this e-mail are those of the sender 
and they do not necessarily constitute those of Aberdeen City Council. Unless 
we expressly say otherwise in this e-mail or its attachments, neither this 
e-mail nor its attachments create, form part of or
  vary any contractual or unilateral obligation. 
Aberdeen City Council's incoming and outgoing e-mail is subject to regular 
monitoring.


--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--