ASP中显示临时表中数据的问题?
我的存储过程是:
ALTER PROCEDURE moneycount
@sendman varchar(20)
AS
DECLARE @order int,
@name varchar(20),
@totol numeric(9),
@discount numeric(9),
@money numeric(9)
select @totol=count(*) from result where parm2=@sendman
select @totol
select @discount=discount from tbuser where uname=@sendman
select @money=@totol*@discount
select @money=@money/10
select @money
--select @money=@money+'元'
CREATE TABLE #t(x numeric,y numeric)
INSERT INTO #t VALUES (@totol,@money)
select * from #t
现在我要在ASP里把X,Y的值显示出来,请问怎么实现?
我的ASP代码是:
<%
set rs=server.createobject("adodb.recordset")
uname=trim(request.querystring("uname"))
sql="execute moneycount '"&uname&"'"
rs.open sql,conn,1,1
%>
<tr>
<td><table width="463" border="1" cellpadding="0" cellspacing="0" bordercolor="#0B62BB" style="BORDER-COLLAPSE: collapse" table>
<tr bgcolor="#DCFBFC" class="style3">
<td width="51" nowrap><div align="center" class="style3">留言者</div></td>
<td width="156" nowrap><div align="center" class="style3">留言总和</div></td>
<td width="129" nowrap><div align="center" class="style3">折扣</div></td>
<td width="157" nowrap><div align="center" class="style3">应收金额</div></td>
</tr>
<%if not rs.eof and not rs.bof then %>
<tr>
<td> <div align="center"><%=uname%></div></td>
<td><div align="center">该用户总共有<%=rs("x")%>条数据</div></td>
<td><div align="center"><%=rs("y")%></div></td>
<td><div align="center"> </div></td>
</tr>
<%
rs.movenext
end if
rs.close
%>
其中uname是有值的,用该值到SQL里面执行是有结果的,X=5,Y=5
为什么在网页里面就没有数据呢?
不知道这样调用是否有问题,请帮忙看看,谢谢!