Re: esql:query problem

2003-06-26 Thread Christian Haul
On 26.Jun.2003 -- 10:04 AM, Dmitry Diskin wrote: > Hello > > I noticed that if I insert any tag between closing and > opening - nothing works. Is it a known situation and > documented somewhere? > > Example below doesn't work: > > > mypool > > > select * from somet

RE: esql:query problem

2003-06-25 Thread Tim Bachta
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

Re: esql:query problem

2003-06-25 Thread Christian Haul
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()'e

RE: esql:query problem

2003-06-25 Thread Tim Bachta
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:

Re: esql:query problem

2003-06-25 Thread Christian Haul
On 25.Jun.2003 -- 10:32 AM, Tim Bachta wrote: > My code now looks like this w/out the tag: > > {call rptLocationDeviations( type="Int">number, direction="in" type="String">room, > type="String">beginTime, > type="String">endTime)} > > > (ResultSet) from-call="true"/> Sorry, I should have bee

RE: esql:query problem

2003-06-25 Thread Tim Bachta
(): org.apache.avalon.framework.CascadingRuntimeException: Error getting ascii data 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

Re: esql:query problem

2003-06-25 Thread Christian Haul
On 25.Jun.2003 -- 09:53 AM, Tim Bachta wrote: > Here is my code in plain Java: > CallableStatement stmt = con.prepareCall("{call > rptLocationDeviations(?,?,?,?)}"); > stmt.setInt(1, 199); > stmt.setString(2, "Rm 130 B"); >

RE: esql:query problem

2003-06-25 Thread Tim Bachta
:[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="Int">number -Roger - Original Message - Fro

Re: esql:query problem

2003-06-25 Thread Roger I Martin PhD
Guessing a little; should it be little case int instead of Int at esql:parameter direction="in" type="Int">number -Roger - Original Message - From: "Tim Bachta" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 10:53 AM

RE: esql:query problem

2003-06-25 Thread Tim Bachta
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 in

RE: esql:query problem

2003-06-25 Thread Tim Bachta
there, granted it is a little confusing to look through since the formatting 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 probl

Re: esql:query problem

2003-06-25 Thread Christian Haul
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 pl

RE: esql:query problem

2003-06-24 Thread Tim Bachta
Here is what I am trying, I am getting an invalid parameter bindings error, do I need to register the out parameters? {? = call rptLocationDeviations(number, room, beginTime , endTime)}