Cocoon/XSP/ESQL help

[Brian Campbell]

Hope this is the appropriate list for this question.

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.



<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp";
xmlns:xsp-request="http://apache.org/xsp/request/2.0";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:log="http://apache.org/xsp/log/2.0";>
<root>
<esql:connection>
<esql:pool>mpts-pool</esql:pool>

<esql:execute-query>
<esql:call>
{ call sp_DayShift_Report_ListByName ((<esql:parameter direction="in"
type="String"><xsp-request:get-parameter name="sQuerry"/></esql:parameter>) }
</esql:call>

<esql:results>
<esql:row-results>
<data>
<esql:get-columns/>
</data>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</root>
</xsp:page>




-Brian


_________________________________________________________________
The new MSN 8: smart spam protection and 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]>