On 26.Jun.2003 -- 10:04 AM, Dmitry Diskin wrote:
Hello
I noticed that if I insert any tag between closing /esql:query and
opening esql:results - nothing works. Is it a known situation and
documented somewhere?
Example below doesn't work:
esql:connection
On 24.Jun.2003 -- 08:48 AM, Tim Bachta wrote:
Here is what I am trying, I am getting an invalid parameter bindings
error, do I need to register the out parameters?
Yes -- unless your driver returns a result set. This is highly
dependent on the jdbc driver :-(
If you know how to do it in
: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 7:37 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 24.Jun.2003 -- 08:48 AM, Tim Bachta wrote:
Here is what I am trying, I am getting an invalid parameter bindings
error, do I need to register the out parameters
Forgot to add that I am getting an invalid parameter bindings error from
cocoon.
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
-Original Message-
From: Tim Bachta
Sent: Wednesday, June 25, 2003 9:53 AM
To: [EMAIL PROTECTED]
Subject: RE: esql:query problem
Here is my code
is not the greatest.
Thanks for the help.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 7:37 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 24.Jun.2003 -- 08:48 AM, Tim Bachta wrote:
Here is what I am trying, I am
:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:11 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
Guessing a little; should it be little case int instead of Int at
esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter
-Roger
- Original Message -
From
On 25.Jun.2003 -- 09:53 AM, Tim Bachta wrote:
Here is my code in plain Java:
snip/
CallableStatement stmt = con.prepareCall({call
rptLocationDeviations(?,?,?,?)});
stmt.setInt(1, 199);
stmt.setString(2, Rm 130 B);
for column 1
We may be getting closer? Thanks for all the help.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:20 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 25.Jun.2003 -- 09:53 AM, Tim Bachta wrote
documentation? I don't know I just wish I could
get this to work. Thanks again for the help it is really appreciated.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:38 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query
On 25.Jun.2003 -- 10:48 AM, Tim Bachta wrote:
Well I tried that and no error, the only problem is I get no results
either. I was looking at the example that I am working from
Maybe you need to add the needs-query attribute. Some drivers don't
like it if a CallableStatement is just execute()'ed
Chris,
That was it, thank you for the help. All of you that helped thank you.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:56 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 25.Jun.2003 -- 10:48 AM, Tim
Here is what I am trying, I am getting an invalid parameter bindings
error, do I need to register the out parameters?
esql:execute-query
esql:call
{? = call rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,
esql:parameter
12 matches
Mail list logo