Start with checking how your logicsheet works standalone, i.e. transform xsp page with you logicsheet by Xalan from the command line. Check result. Give resulting xsp page to the Cocoon. See it compiles.
Vadim > From: Peter Wieland [mailto:[EMAIL PROTECTED]] > > Hi, > > I'm trying for one day to get a logicsheet to do some work for me. I want to > print out a drop down menu with values from a database and the format > speciefied in my xsp source. > > here is the relevant part of the xsp-page (test.xsp) > --------------------------------- > <list> > <tiana-sql:listboxitems table="TianaUser"> > <tiana-sql:itemelement type="column">Id</tiana-sql:itemelement> > <tiana-sql:itemelement type="text"> - </tiana-sql:itemelement> > <tiana-sql:itemelement > type="column">FirstName</tiana-sql:itemelement> > <tiana-sql:itemelement type="text"> </tiana-sql:itemelement> > <tiana-sql:itemelement > type="column">LastName</tiana-sql:itemelement> > </tiana-sql:listboxitems> > </list> > --------------------------------- > > and some parts of my tiana-sql logicsheet > --------------------------------- > <xsl:template name="get-columns"> > <xsl:for-each select="tiana-sql:itemelement[@type='column']"> > <xsl:text>, </xsl:text> > <xsp:logic>TianaSQLHelper.getTablePrefix(objectModel, "<xsl:value-of > select="parent::*/@table"/>")</xsp:logic><xsl:value-of select="."/> > </xsl:for-each> > </xsl:template> > > <xsl:template match="tiana-sql:listboxitems[@table]"> > <xsl:variable name="idcolumn"> > <xsp:logic>TianaSQLHelper.getIdColumn(objectModel, "<xsl:value-of > select="@table"/>")</xsp:logic> > </xsl:variable> > > <xsl:variable name="in-cond"> > <xsl:if test="@in-cond"> WHERE <xsl:value-of select="$idcolumn"/> IN > (<xsl:value-of select="@in-cond"/>)</xsl:if> > </xsl:variable> > > <esql:connection> > <esql:pool>tiana</esql:pool> > <esql:execute-query> > <esql:query> > <xsl:text>SELECT </xsl:text> > <xsp:logic>TianaSQLHelper.getIdColumn(objectModel, "<xsl:value-of > select="@table"/>")</xsp:logic> > <xsl:text> AS Id</xsl:text> > <xsl:call-template name="get-columns"/> > <xsl:text> FROM </xsl:text><xsl:value-of select="@table"/> > <xsl:value-of select="$in-cond"/> > </esql:query> > <esql:results> > <esql:row-results> > <item> > <value><esql:get-string column="Id"/></value> > <text> > <xsl:for-each select="tiana-sql:itemelement"> > <xsl:choose> > <xsl:when test="@type='text'"> > <xsl:value-of select="."/> > </xsl:when> > <xsl:when test="@type='column'"> > <!--<esql:get-string> > <esql:column>--> > <xsp:logic>TianaSQLHelper.getTablePrefix(objectModel, > "<xsl:value-of select="parent::*/@table"/>") + "<xsl:value-of > select="."/>"</xsp:logic> > <!--</esql:column> > </esql:get-string>--> > </xsl:when> > </xsl:choose> > </xsl:for-each> > </text> > </item> > </esql:row-results> > </esql:results> > </esql:execute-query> > </esql:connection> > </xsl:template> > --------------------------------- > > This works fine as long as I comment out the part, where I actually do the > db request (I just get the names of the columns printed out, instead of the > columns). But if I include this request, I get class not found exceptions, > what is not very surprising as an empty test_xsp.java file is generated. But > why is this file empty. When I use <xsp:expr> ... </> instead of logic, I > get an compile error because of a missing ";" in my test_xsp.java. > > Can anybody give me a hint how I could get my application working? > > By the way, I never really understood when to use xsp:expr and xsp:logic or > both of them. And what is the sense of xsp:component? > > Thanks for any help, > > Peter > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
