cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Bachta" <tbac...@kopent.com>
Subject RE: Stored Procedure Help
Date Tue, 24 Jun 2003 16:25:12 GMT
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:frank.taffelt@interface-business.de] 
Sent: Tuesday, June 24, 2003 11:17 AM
To: cocoon-users@xml.apache.org
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: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


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