On 18.Jun.2002 -- 07:40 PM, System Administrator wrote:
> This is inside a logicsheet.
>
> I have a database configuration xml schema.
> I am attempting to create an xsp page from the
> database xml, which will perform database actions on
> the fields defined in the xml.
>
> On creating the xsp page, I have defined table tags.
>
> On executing the xsp page, I need to get attributes
> from the table tags and use a column name to perform a
> database query.
>
> the "column1" part of the code is really a
> <xsl:value-of select="@columnName">
>
> > > I'm having problems passing an xsl variable as a
> > parameter to esql.
> > >
> > > 1 - I am defining a column name as a variable
> > called col1.
> > > 2 - I want to use this variable as the column
> > value in the
> > > <esql:get-string > tag.
> > >
> > > This is not working, producing a language
> > exception
> > >
> > >
> > > <xsl:variable name="col1">
> > > column1
> > > </xsl:variable>
> > >
> > >
> > > <esql:results>
> > > <esql:row-results>
> > > <esql:get-string column="{$col1}" />
> > > </esql:row-results>
> > > </esql:results>
> > >
> > >
> > > Is this the right way to do this?
Yes. I assume that {$col1} is a static value since your XSP would need
to be regenerated manually after every schema change.
The biggest problem I see with your code is the whitespace around the
column name. The JDBC driver will most likely not consider "column1"
and "
column1
" as equal. (linebreaks were intended!) Eliminate all whitespace in
your variable or use XSLT functions to trim it.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
