Question

ASP 如何获取select count(*) from tablename 返回的值

sql2="select count(wenba_id) as nums from replywenba where wenba_id="&id&""这样调用不行<%=rs2("nums")%>求高手帮忙..

Answer 1

<% dim id,i
id=rs("id")
set rs2=server.createobject("adodb.recordset")
sql2="select count(wenba_id) as nums from replywenba where wenba_id="&id&""
rs2.open conn,sql2,1,2
%>
<%=rs2(0)%>
<%rs2.close%>

Answer 2

wenba_id=&'"+id+"'&"