cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Miller, Grant" <Grant.Mil...@COGNOS.com>
Subject RE: Calling MS SQL stored procedure
Date Fri, 22 Feb 2002 10:13:36 GMT
Thanks. Actually we've got it to work now, all it was was that the
in-parameter tag needed the sql namespace!

-----Original Message-----
From: neil [mailto:nbacon@aisoftware.com.au]
Sent: Thursday, February 21, 2002 10:30 PM
To: cocoon-users@xml.apache.org
Subject: RE: Calling MS SQL stored procedure


I'm using <substitute-value> instead of IN parameters:
<query isstoredprocedure="true">{ ? = call sp(
	'<substitute-value sql:name="string_value"/>',
	<substitute-value sql:name="int_value"/>
	) }</query>

The MS JDBC driver had trouble parsing a query with new lines in it,
but at least it gets by with one long line.

In reply to:
http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=101429060624988&w=2


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.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