AW: esql:query problem

2003-06-23 Thread Michael Raffenberg
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Gesendet: Montag, 23. Juni 2003 22:55
 An: [EMAIL PROTECTED]
 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:exprroom/xsp:expr','xsp:exprbeginTime/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: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 
 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: AW: esql:query problem

2003-06-23 Thread Chris

look at: esql:get-xml


--- Michael Raffenberg [EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
  Gesendet: Montag, 23. Juni 2003 22:55
  An: [EMAIL PROTECTED]
  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:exprroom/xsp:expr','xsp:exprbeginTime/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: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]
  
  
 
 
 -
 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]