cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris <chri...@yahoo.com>
Subject Re: AW: esql:query problem
Date Tue, 24 Jun 2003 00:41:24 GMT

look at: esql:get-xml


--- Michael Raffenberg <michael.raffenberg@t-online.de> wrote:
> 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
> 


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