Using the Allaire JRun taglib, how can I retrieve the return status from
a stored procedure (Sybase 10.5 or MS sql)? E.g, see code below:
I've tried everything I could think of and went through all the
documentation provided.
Used: Jconnect JDBC Driver, NT4 SP6, Sybase 11.5
#################
# table and some values
#################
CREATE TABLE dbo.xx
(
a int NOT NULL,
b int NOT NULL,
c int NOT NULL,
)
insert into xx values (6,5,4)
#################
# stored proc def
#################
create proc SP_TEST
as
begin
select * from xx
return 1
end
#################
# jsp page source
#################
<jrun:sql datasrc="offspring_auction" id="rs">
exec SP_TEST
</jrun:sql>
<jrun:param id="rs" type="QueryTable" scope="page"/>
rows=<%= rs.getRowCount(); %><br>
cols=<%= rs.getColumnCount(); %><br>
col num 2=<%= rs.getColumnLabel(2); %><br>
return status=<%= rs.get("returnStatus????"); %><br> <------------ How
to get the status???
<jrun:foreach group="<%= rs %>">
x=<%= rs.get(1); %><br>
y=<%= rs.get(2); %><br>
z=<%= rs.get(3); %><br>
</jrun:foreach>
#################
# page output
#################
rows=1
cols=3
col num 2=b
return status=
x=6
y=5
z=4
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
