INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

XML/XSL help

XML/XSL help

(OP)
Hi guys, i'm really new at xml and xsl. all im tyring to do is grab information from the xml then use an xsl file to perform a sql insert. I'm trying to get all <a> values from the different <id>'s.

Please help:

Here's the xml im using:

<?xml version="1.0" encoding="utf-8" ?>
- <survey xmlns="http://www.truecontext.com/survey"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:survey="http://www.truecontext.com/survey">

  - <questionnaire>
      - <q>
          <id>0</id>
        </q>
      - <q>
           <id>1</id>
           <a>40</a>
        </q>
     - <q>
          <id>2</id>
          <a>Iwork</a>
       </q>
  </questionnaire>
  </survey>

And here's the xsl im working on:
<xsl:stylesheet version="1.0"
      xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
      xmlns:s="http://www.truecontext.com/survey">
 
      <xsl:output method="xml"/>
      
      <xsl:template match="/ns:survey">
            <xsl:element name="SQL">
                  <xsl:apply-templates select="ns:questionnaire/ns:q"/>
            </xsl:element>
      </xsl:template>
 
      <xsl:template match="ns:q/[child::ns:id=1]">
            <xsl:element name="Command">
                  <xsl:attribute name="nonQuery">
                        <xsl:text>false</xsl:text>
                  </xsl:attribute>
                  <xsl:attribute name="type">
                        <xsl:text>text</xsl:text>
                  </xsl:attribute>
                  
          
           <xsl:text>INSERT INTO Staff (StaffID) VALUES ('</xsl:text>
                  <xsl:value-of select="ns:a"/>
                  <xsl:text>')</xsl:text>
                         


            </xsl:element>
      </xsl:template>
      
</xsl:stylesheet>

Thank you in advance.
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close