On Wed, 13 Jun 2001 10:07:07 -0500
Gustavo Mejia [EMAIL PROTECTED] wrote:
And now It works, but now what I wanto to do i to make variable the criteria of
my query, yes, something like
esql:queryselect * from employee where empno=MY_VARIABLE/esql:query
Do you know how can I do that ?
Hi,
I am using Cocoon 1.8.2, and I am trying to run this query, but I don't
see any result
My code here :
?xml version=1.0?
?cocoon-process type=xsp?
xsp:page
language=java
xmlns:esql=http://www.apache.org/1999/SQL/v2;
xmlns:xsp=http://www.apache.org/1999/XSP/Core;
-
-Original Message-
From: Gustavo Mejia [mailto:[EMAIL PROTECTED]]
Sent: mercoledì 13 giugno 2001 16.16
To: [EMAIL PROTECTED]
Subject: Problem with my query
Importance: High
Hi,
I am using Cocoon 1.8.2, and I am trying to run this query, but I don't
see
Gustavo,
try this:
esql:queryselect * from employee where empno=
esql:parameterMY_VARIABLE/esql:parameter
/esql:query
You may need to specify a type, such as esql:parameter type=int,
otherwise it will assume a String.
-Christopher
Thanks,
I chanche my code to:
?xml version=1.0?
Thanks Christopher,
But now, how can I assign the variable from other XML, how can I pass to
the XML with my query ?
I really apreciate your hellp !
Gustavo
Christopher Painter-Wakefield wrote:
Gustavo,
try this:
esql:queryselect * from employee where empno=
Thanks again,
Right, I need to do the first thing that you told me, I tried but with no
results, I have something like this:
esql:queryselect * from employee
where empno=esql:parameterVAR/esql:parameter
/esql:query
and in my browser the url is:
Gustavo,
you want to use the request taglib, for which there isn't any documentation
(hopefully soon there will be). Anyway, try this:
esql:query
select * from employee where empno=
esql:parameter
request:get-parameter name=VAR/
/esql:parameter
/esql:query
You'll need to add a