RE: sql, xml & forms

Subject: RE: sql, xml & forms
From: "Dawson, Geoff F" <Geoff.Dawson@xxxxxxxxxxxxxxx>
Date: Wed, 8 Mar 2000 13:25:39 -0000
The problem is in your template for ROW. 

>  <xsl:template match="ROW">
>    <xsl:variable name="category">
>        <xsl:apply-templates/>
>    </xsl:variable>
>    <INPUT TYPE="RADIO" NAME="category" VALUE="{$category}"/>{$category}
>  </xsl:template>

I don't understand why you have put an <xsl:apply-templates/> in here as I
assume that ROW is the lowest level element. If so then what you need is:

  <xsl:template match="ROW">
    <INPUT TYPE="RADIO" NAME="category" VALUE="{.}"/><xsl:value-of
select="."/>
  </xsl:template>

Geoff

> -----Original Message-----
> From: Kari M. Scott [mailto:kmscott@xxxxxxxxxxxxxxxx]
> Sent: 07 March 2000 18:08
> To: xsl-list@xxxxxxxxxxxxxxxx
> Subject: sql, xml & forms
> 
> 
> 
> Hello, 
> 
> I'm trying to pass the results of a sql query in an xml file 
> to a variable
> in my xsl stylesheet using the xsl:variable element and plugging the
> variable into a form and I'm not having any luck discovering 
> the correct
> syntax. If someone has any simple examples of using xml with forms or
> examples of the xsl:variable element they could send me, I'd really
> appreciate it.  Or, here are my xml and xsl files; what am I 
> doing wrong?  
> Thanks in advance.
> 
> -Kari
> 
> 
> _________form.xml______________
> <?xml version="1.0" encoding="iso-8859-1"?>
> 
> <?cocoon-process type="sql"?>
> <?cocoon-process type="xslt"?>
> <?xml-stylesheet href="form.xsl" type="text/xsl"?>
> 
> <page>
> <title>Passing Variables</title>
>  <connectiondefs>
>   <connection name="foo_connection">
>    <driver>org.gjt.mm.mysql.Driver</driver>
>    <dburl>jdbc:mysql://localhost/test</dburl>
>   </connection>
>  </connectiondefs>
> 
>  <query connection="foo_connection" doc-element="CATEGORY"
> row-element="ROW">
>         select child_name from cat_children
>  </query>
> </page>
> 
> 
> ---------form.xsl
> <?xml version="1.0"?>
> 
> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
> 
>   <xsl:template match="page">
>    <xsl:processing-instruction
> name="cocoon-format">type="text/html"</xsl:processing-instruction>
>    <html>
>     <head>
>      <title>
>       <xsl:value-of select="title"/>
>      </title>
>     </head>
>     <body bgcolor="#ffffff">
>         <form action="results.xml" method="post">
>           <BR>Please select a category:</BR>
>           <xsl:apply-templates select="CATEGORY"/>
>           <P><input type="submit" value="Submit"></P>
>         </form>
>     </body>
>    </html>
>   </xsl:template>
> 
>   <xsl:template match="CATEGORY">
>     <xsl:apply-templates select="ROW">
>     </xsl:apply-templates>
>   </xsl:template>
> 
>   <xsl:template match="ROW">
>     <xsl:variable name="category">
>         <xsl:apply-templates/>
>     </xsl:variable>
>     <INPUT TYPE="RADIO" NAME="category" 
> VALUE="{$category}"/>{$category}
>   </xsl:template>
> 
> </xsl:stylesheet>
> 
> 
> 
> Kari M. Scott
> Berbee
> 5520 Research Park Drive
> Madison, WI  53711-5377
> kmscott@xxxxxxxxxx
> 608.288.3000 ext. 1223
> 608.298.1223 direct dial
> 608.288.3037 fax
> 
> Berbee...putting the E in business
> 
> 
> 
> 
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread