I am using MS SQL 2000 as a database. I am trying to run a stored procedure using the following code:
<esql:execute-query> <esql:call> {? = call rptLocationDeviations(<esql:parameter direction="in" type="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter direction="in" type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:parameter direction="in" type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:para meter direction="in" type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)} </esql:call> <esql:call-results> <esql:use-results> <esql:result><xsp:expr><esql:get-object column="1" from-call="true"/></xsp:expr></esql:result> <esql:results> <esql:row-results> <test> <esql:get-string column="1"/> </test> </esql:row-results> </esql:results> </esql:use-results> </esql:call-results> </esql:execute-query> I am getting back an error message of invalid parameter bindings. I checked my input parameters and they are set up correctly. Any suggestions would be greatly appreciated. Thank you Tim Bachta --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]