cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacob Arnold <Jac...@envworld.com>
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?
>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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message