Thanks for your replies on this mail, most gratefully received.
The problem was with the whitespace around the variable value.
If there is whitespace in the value then the database query will
not work. However, if there is a newline in the value then the
compiler throws an error with a language exception.
Kindest regards
Graeme Colman.
---------- Original Message ----------------------------------
From: Christian Haul <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 19 Jun 2002 09:15:33 +0200
>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: <cocoon-users-
[EMAIL PROTECTED]>
>For additional commands, e-mail: <cocoon-users-
[EMAIL PROTECTED]>
>
>
---------------------------------------------------------------------
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]>
