cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From michael.raffenb...@t-online.de (Michael Raffenberg)
Subject AW: esql:query problem
Date Tue, 24 Jun 2003 00:24:53 GMT
Hi Tim, 

did you try the <esql:call> Tag?
Here you find a introduction:
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Support

--Raffy

> -----Urspr√ľngliche Nachricht-----
> Von: tbachta@kopent.com [mailto:tbachta@kopent.com] 
> Gesendet: Montag, 23. Juni 2003 22:55
> An: cocoon-users@xml.apache.org
> Betreff: esql:query problem
> 
> 
> I am attempting to call a stored procedure using esql:query.  
> Other stored procedures work using this so it is not a 
> connection issue.  I have narrowed down the issue to being 
> the procedure itself.  I am selecting data and inserting it 
> into a temp table then selecting more data and joining the 
> two data sets.  I need to use the temp tables there is no way 
> around it.  The problem is the stored procedure will not 
> return a result set in cocoon because it sees the insert 
> statement then stops thinking there is not a result set.  My 
> code from my xsp is below, if anyone has any information 
> about why this does not work it would be greatly appreciated. 
>  Thank you
> 
>  
> 
>  
> 
> Tim Bachta
> 
>  
> 
> <esql:execute-query>
> 
>                                  <esql:query>
> 
>                                         execute a_joe 
> '<xsp:expr>room</xsp:expr>','<xsp:expr>beginTime</xsp:expr>','
> <xsp:expr>
> endTime</xsp:expr>'
> 
>                                  </esql:query>
> 
>                                  <esql:results>
> 
>                                         <task-dates>
> 
>                                                <esql:row-results>
> 
>                                                       <task-date>
> 
>                                                             <date>
> 
>  
> <esql:get-string column="1"/>
> 
>                                                             </date>
> 
>                                                      
> 
>                                                                    
> 
>                                                      </task-date>
> 
>                                                      
> 
>                                                </esql:row-results>
> 
>                                         </task-dates>
> 
>                                  </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