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

Reply via email to