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