计算后的数据显示问题!(急!)

[dgseamaple]

计算符合条件的数量总和
sql="select sub(many) from book where idcode=&request.form("idcode")&"
set rs2=execute(sql)

请问在显示时该如何调用合计数？
<td>合计：??如何把合计数显示出来??</td>

[qiushuiwuhen]

sql="select sub(many) from book where idcode=&request.form("idcode")&"
=>
sql="select sum(many) from book where idcode="&request.form("idcode")


<td>合计：<%=rs2(0)%></td>

[gshope]

sql="select sub(many) as aa from book where idcode=&request.form("idcode")&"
...
<%=rs("aa")%>
...

[sdly]

sql="select sum(many) as zh from book where idcode=&request.form("idcode")&"
rs.fields("zh")

[dgseamaple]

我试试，谢谢各位

[dgseamaple]

出错信息为：
Microsoft VBScript 编译器错误 错误 '800a03fd'
缺少 'Case'
何解？

[dgseamaple]

sql="select sum(howmany) as how from charge where ename="&cint(request.form("ename"))
set rs2=Execute(sql)===============这一句出错！缺少'Case'

[qiushuiwuhen]

set rs2=conn.Execute(sql)
conn为adodb.connection

[dgseamaple]

楼上的兄台，我竟连这一句也不小心写错了，真是太感谢你了！