XSL for XML database 1

cathiec · Oct 21, 2003

Hello there!
I have the following simple XML database:

<?xml version="1.0"?>
<?xml-stylesheet href = "sample.xsl" type = "text/xsl"?>
<!DOCTYPE Quiz SYSTEM "sample.dtd">

<Quiz Status="NewVersion">
<QuestionsAnswers QuestionNumber="1"

Question="1"

Answer1 ="correct"
Answer2 ="correct"
Answer3 ="correct"
Answer4 ="correct"
/>

</Quiz>

The following dtd describes the Database:

<?xml version="1.0"?>
<!ELEMENT Quiz (QuestionsAnswers*)>
<!ATTLIST Quiz
Status (NewVersion | UpdatedVersion | CourtesyCopy) #REQUIRED>
<!ELEMENT QuestionsAnswers EMPTY>
<!ATTLIST QuestionAnswers
QuestionNumber CDATA #REQUIRED
Question CDATA #REQUIRED
Answer1 CDATA #REQUIRED
Answer2 CDATA #REQUIRED
Answer3 CDATA #REQUIRED
Answer4 CDATA #REQUIRED
>

I am trying to create an xsl stylesheet that will display the question and then underneath this the four answers each with a corresponding radio button. All I have is the following:

<?xml version = "1.0"?>
<xsl:stylesheet xmlns:xsl = "

http://www.w3c.org/1999/XSL/Transform"

version = "1.0">
<xsl

utput method = "html"/>

<xsl:template match = "Quiz">

<body bgcolor = "#FFDDFF">
<p><xsl:apply-templates/></p>
</body>
</xsl:template>
</xsl:stylesheet>

I really would appreciate any help as my xsl skills are quite basic

regards,
cathie

harebrain · Oct 23, 2003

I think your XML is bad: you've left yourself no way to iterate through your attributes in a meaningful way without examining the name of each attribute, which just makes it all harder. (You've included data in the attribute names themselves. Bad form.) Wouldn't something like this be better:

Code:

<?xml version=&quot;1.0&quot;?>
<quiz status=&quot;New Version&quot;>
  <item number=&quot;1&quot;>
    <question>When did Columbus discover America?
      <answer choice=&quot;A&quot;>1492</answer>
      <answer choice=&quot;B&quot;>Columbus didn't discover America, Indians did.</answer>
      <answer choice=&quot;C&quot;>Columbus was a putz: he thought he was in India.</answer>
      <answer choice=&quot;D&quot;>Columbus didn't discover America, native Americans did.</answer>
    </question>
  </item>
</quiz>

Now, you can use an XSL template to select the

Code:

answer

nodes and output whatever you want.

IOW, if you put more thought into the XML (i.e., structuring the data) and how you're going to use it, the XSL will be less of a problem.

HTH,
harebrain

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

XSL for XML database 1

cathiec

Programmer

harebrain

MIS

Similar threads

Part and Inventory Search

Sponsor