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:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 10:30 PM To: [EMAIL PROTECTED] 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>