But I'm wondering if this might have found minor a problem with Cocoon. The error I was getting back (several emails below) was something about a weird syntax error. I went into the generated class in the work directory, cut the code and pasted it into a test class. Instead of using the EsqlQuery class, I just used CallableStatement, etc. I immediately got a much more accurate statement from the JDBC driver. It wouldn't surprise me if its a problem/bug in the Microsoft driver but since I got different results by using the basic java.sql.* classes, I'm wondering if its something else Cocoon is doing.
Thanks to all, especially Geoff, who helped.
-Brian
I have looked at the code. Don't see anything wrong off hand but I think I'll yank it out of there and put it in a small test class. Maybe that will tell me some more.
The quotes are extra and not needed. I've just been trying every variation that I can think of.
-Brian
Have you looked at the generated java file under the work directory? That
usually clears up mysterious xsp problems for me.
Do you need the single quotes around the parameter value (thought esql would
put them in for you)
Geoff Howard
>
>
> -Brian
>
>
>
>
> >
> >Yeah, I caught that and fixed it already. It was a problem, but not the
> >end of my problems.
> >
> >-Brian
> >
> >
> >
> >
> >>From: Jacob Arnold <[EMAIL PROTECTED]>
> >>Reply-To: [EMAIL PROTECTED]
> >>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> >>Subject: RE: Cocoon/XSP/ESQL help
> >>Date: Fri, 10 Jan 2003 14:39:49 -0700
> >>
> >> >I have a simple XSP page. I want to use ESQL to call stored
> procedures
> >>in
> >> >a Microsoft SQL Server database. I've got my connection pool set up
> >> >correctly. I'm able to execute simple select statements and
> I'm able to
> >> >execute a stored procedure that doesn't take any parameters.
> But most
> >>of
> >> >my stored prcedures take parameters. Can't seem to find any good
> >>examples
> >> >anywhere. My code is below. Anyone able to tell me what I'm doing
> >>wrong?
> >> >Thanks.
> >>
> >><esql:call>{ call sp_DayShift_Report_ListByName((<esql:parameter
> >>direction="in" type="String"><xsp-request:get-parameter
> >>name="sQuerry"/></esql:parameter>) }</esql:call>
> >>
> >>On second glance, it looks like you may have an extra open parenthesis.
> >>
> >>J
> >>
> >>---------------------------------------------------------------------
> >>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]>
> >
> >
> >_________________________________________________________________
> >STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> >http://join.msn.com/?page=features/junkmail
> >
> >
> >---------------------------------------------------------------------
> >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]>
>
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> ---------------------------------------------------------------------
> 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]>
>
>
>
---------------------------------------------------------------------
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]>
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
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]>
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
---------------------------------------------------------------------
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]>
