cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacob Arnold <>
Subject RE: Cocoon/XSP/ESQL help
Date Fri, 10 Jan 2003 21:39:49 GMT
>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?

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


Please check that your question  has not already been answered in the
FAQ before posting.     <>

To unsubscribe, e-mail:     <>
For additional commands, e-mail:   <>

View raw message