Gustavo,
if you want to send me your code (you can send it directly to me) I'll be
glad to take a look. At a guess, though, I would think that your query
just isn't returning any data. I assume you are passing in a valid
paremeter in your request string. Perhaps your database is expecting an
integer and you are giving it a string, or vice-versa.
You should probably spend some time looking at what you are getting from
your request parameters to help you get familiar with what is happening.
Just write a simple XSP page something like:
...
<xsp:page
xmlns:xsp="http://www.apache.org/1999/XSP/Core";
xmlns:request="http://www.apache.org/1999/XSP/Request";
>
<html>
<b>VAR =</b> <request:get-parameter name="VAR"/>
</html>
</xsp:page>
You should also take a look at the generated Java code to see if that sheds
any light. The Java code will be in your repository. The location of the
repository is defined in your cocoon.properties. Looking at the code is a
good way to begin to understand what is really going on when you write XSP,
and will help you make better guesses as to the proper syntax to use.
Good luck.
-Christopher
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: Problem with my query
Christopher sorry for all the troubles,
But, I didn't get it, I tried it, there is not any error message, but there
is not any result.
any other idea ??
Thanks so much !
Gustavo
Christopher Painter-Wakefield wrote: 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 declaration for the request namespace in your xsp:page
element, like this:
xmlns:request="http://www.apache.org/1999/XSP/Request";
I think you will need to take out the quotes on your query string, like
this:
http://localhost/cocoon/servlet/sql/esql.xml?VAR=000001
-Christopher
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
