Hi
One small suggestion, Many user reply for a problem and that get solved, so
why don't the initial question sender share the how to setup which is
working with the code. May be these kind of small thinks can help newbie to
understand better.
Regards
Sreenivasan.
At 09:25 AM 6/19/02 +0100, you wrote:
>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]>
"Attitudes are much more important than aptitudes."
"Nothing is impossible for a willing heart"
Sreenivasan N.
Sony SARD
Ext 232
Email. [EMAIL PROTECTED]
Per: [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]>
