Ok, I am not having a problem with the input parameters it is the output
parameter that I am having issues with. This is more of a callable
statement than a stored procedure. Here is what I am trying to no
avail.
<esql:execute-query>
<esql:call>
{<esql:parameter type="Int" direction="out"/>=call
getLoginResult(<esql:parameter type="String"
direction="in"><xsp:expr>user</xsp:expr></esql:parameter>,<esql:paramete
r type="String"
direction="in"><xsp:expr>password</xsp:expr></esql:parameter>)}
</esql:call>
<esql:results>
<esql:call-results>
<xsp:logic>
login = <esql:get-int column="1" from-call="yes"/>;
</xsp:logic>
</esql:call-results>
</esql:results>
</esql:execute-query>
Thanks
Tim
-----Original Message-----
From: Frank Taffelt [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 2:40 AM
To: [EMAIL PROTECTED]
Subject: Re: MS SQL Stored Procedure Help
this is a snippet which works for me under mssql (jtds driver):
<esql:call>
{call proc_info(
<esql:parameter
type="Int"><xsp:expr>Integer.parseInt(id)</xsp:expr></esql:parameter>
)}
</esql:call>
<esql:results>
<esql:row-results>
...
</esql:row-results>
</esql:results>
i'm remembering problems with the positioning of "{" and the following
"call" keyword. You have to make sure that there is no space between
them.
I'm not sure if this a jdbc driver issue or strictly enforced by jdbc,
but
this drived my crazzy.
hth,
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
