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

Reply via email to