cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Bachta" <tbac...@kopent.com>
Subject MS SQL Stored Procedure Help
Date Thu, 05 Jun 2003 19:24:49 GMT
I am trying to call this procedure using cocoon.  getLoginResult.  This
stored procedure takes 2 strings and returns an int.  My code is below
but I am getting an error of incorrect syntax near {.  I have tried
literally hundreds of different combinations with nothing working can
someone please show me the light?

<esql:connection>

<esql:pool>vyzo</esql:pool>

<esql:execute-query>

<esql:call>

{ getLoginResult (<esql:parameter direction="in"
type="String"><xsp:expr>user</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>password</xsp:expr></esql:parameter>)}

</esql:call>

<esql:results>

<esql:row-results>

<data>

<xsp:logic>

 login = <esql:get-int column="1"/>;

</xsp:logic>

</data>

</esql:row-results>

</esql:results>

</esql:execute-query>

</esql:connection>

 

 

Thank you

 

Tim

 


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