cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Campbell" <becamp...@hotmail.com>
Subject RE: Cocoon/XSP/ESQL help
Date Fri, 10 Jan 2003 21:28:28 GMT
Thanks for the info.  Unfortunately, I've already been to both places and 
have been unable to determine whats wrong.  My code appears (at least to me) 
to be correct according to the taglib doc and info out at the archives.  Its 
probably something small snd stupid that I'm doing.

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


_________________________________________________________________
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message