-Brian
Here's some places you can go for examples:
ESQL Page in Docs
http://xml.apache.org/cocoon/userdocs/xsp/esql.html
Mailing List ARChives:
http://marc.theaimsgroup.com/?l=xml-cocoon-users
(just do a search on "stored procedure")
J
-----Original Message-----
From: Brian Campbell [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 12:53 PM
To: [EMAIL PROTECTED]
Subject: Cocoon/XSP/ESQL help
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]>
---------------------------------------------------------------------
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]>
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---------------------------------------------------------------------
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]>
