cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "System Administrator" <r...@black-dog-consultants.co.uk>
Subject Re: Pass a xsl variable as a esql tag parameter?
Date Wed, 19 Jun 2002 08:25:32 GMT
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 <haul@dvs1.informatik.tu-darmstadt.de>
Reply-To: haul@dvs1.informatik.tu-darmstadt.de
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
>haul@informatik.tu-darmstadt.de
>    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-
unsubscribe@xml.apache.org>
>For additional commands, e-mail:   <cocoon-users-
help@xml.apache.org>
>
>
 



 
                   

---------------------------------------------------------------------
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-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message