28,391
社区成员
发帖
与我相关
我的任务
分享
set rs = server.createobject("adodb.recordset")
sql = "select * from pz where datediff(m,sqdate,now())=0 and sales ='"+session("realname")+"' and vision = 1 order by id desc"
rs.cursorlocation = 3 '使用客户端游标,可以使效率提高
rs.Open sql,conn,3,3
jiesuan_ts_month = RS.RecordCount 'totalrec:总记录条数