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