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!
  • Students Click Here

*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.

Students Click Here


XML/XSL help

XML/XSL help

XML/XSL help

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"

  - <questionnaire>
      - <q>
      - <q>
     - <q>

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


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!


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