UC知道ASP 怎样显示出结果?
来源：百度知道 编辑：UC知道 时间：2024/05/05 05:06:36
用这句SQL计数,,,怎样才能把所得的数提出来呢???
set rs2=server.createobject("adodb.recordset")
str="select count(*) from 客户"
rs2.open str,conn,3,1
请大家看看看!
set rs2=server.createobject("adodb.recordset")
str="select count(*) from 客户"
rs2.open str,conn,3,1
请大家看看看!
你有二种方法.
str="select count(*) as num from 客户"
rs(num)
str="select count(*) from 客户"
rs(0)
set rs2=server.createobject("adodb.recordset")
str="select count(*) num from 客户"
rs2.open str,conn,1,1
response.write("客户数:"&cstr(rs2("num")))
Response.Write rs2.Fields(0).Value