28,391
社区成员
发帖
与我相关
我的任务
分享
sqlnum="select count(*) from Torder where FHstatus<>'3'"
set rsnum=server.CreateObject("adodb.recordset")
rsnum.open sqlnum,conn,1,1
wfhnum=rsnum.RecordCount
response.Write(rsnum.RecordCount)
rsnum.close
set rsnum=nothing
sqlnum="select count(*) as abc from Torder where FHstatus<>'3'"
set rsnum=server.CreateObject("adodb.recordset")
rsnum.open sqlnum,conn,1,1
wfhnum=rsnum("abc")
response.Write rsnum("abc")
rsnum.close
set rsnum=nothing
sqlnum="select count(0) from test where title<>'111'"
set rsnum=server.CreateObject("adodb.recordset")
rsnum.open sqlnum,conn,1,1
response.Write rsnum(0).value
rsnum.close
set rsnum=nothing