RE: Stored Procedure Help

[Tim Bachta]

It's a different error this time.  
Error getting ascii data for column ActionName

Thanks for the help

Tim Bachta
 

-----Original Message-----
From: Frank Taffelt [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 24, 2003 11:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Stored Procedure Help

try the following:



<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:results>
         <esql:row-results>
          <test>
           <!-- I'm not sure if this is correct,
              because param 1 is the returned resultset.
              use an explicit column name from your resultset
              instead -->
            <esql:get-string column="1"/>
          </test>
       </esql:row-results>
     </esql:results>
  </esql:execute-query>


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