>
> I put in code to dump the message and here is what I get:
>
> [Microsoft][SQLServer 2000 Driver for JDBC]Syntax error at token
> {Call, line
> 0 offset 0.
>
> It appears to be a syntax error with the SP call. Since I can run other
> stored procedures that take no parameters, with no problems at
> all, I assume
> its gotta be the parameter. But I just can't see what it is:
>
> <esql:call>
> {Call
> sp_DayShift_Report_ListByName (<esql:parameter direction="in"
>
>
> type="String">'00000000-0000-0000-0000-000000000000'</esql:parameter>)}
> </esql:call>
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]>
