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]
