[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>
-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]>
