acces统计记录集:sql="select * from "+m_tb+" where ParentId="+Cstr(m_prtID)+" order by orders asc"
set rs=GF_GetRs(sql)
rCount=rs.recordcount
请问一下用sql sever统计记录集:也用到上面2个步骤:
sql="select * from "+m_tb+" where ParentId="+Cstr(m_prtID)+" order by orders asc"
set rs=GF_GetRs(sql)
然后接下来如何统计记录集的数目?请高手指点一下。有急用
set rs=GF_GetRs(sql)
rCount=rs.recordcount
请问一下用sql sever统计记录集:也用到上面2个步骤:
sql="select * from "+m_tb+" where ParentId="+Cstr(m_prtID)+" order by orders asc"
set rs=GF_GetRs(sql)
然后接下来如何统计记录集的数目?请高手指点一下。有急用
如果rs是DataSet
rs.Tables[0].Rows.Count
set rs=GF_GetRs(sql) 不知道GF_GetRs你这里是写的set rs = server.createObject("adodb.recordset")
rs.open sql,conn,1,1
count = rs.recordCountorsql="select count(*) as total from "+m_tb+" where ParentId="+Cstr(m_prtID)+" order by orders asc"
set rs=GF_GetRs(sql)
count = rs(total)
set rs=GF_GetRs(sql)
count = rs("total")