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 20:34:11 GMT
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:becampbel@hotmail.com]
Sent: Friday, January 10, 2003 12:53 PM
To: cocoon-users@xml.apache.org
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>

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