%set rs=server.createobject("adodb.recordset")
'装饰信息
rs.open "select * from SMT_sca where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
scacount=rs.recordcount
rs.close
'产品
rs.open "select * from SMT_cp where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
cpcount=rs.recordcount
rs.close
'招聘
rs.open "select * from SMT_job_zp where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
zpcount=rs.recordcount
rs.close
'求职
rs.open "select * from SMT_job_qz where SMT_key=1 and SMT_key1=1 and SMT_key2=1 and SMT_iname is not null",conn,1,1
qzcount=rs.recordcount
rs.close
'企业
rs.open "select * from SMT_yp where SMT_key<>0 and SMT_key<>2 and SMT_key1=1",conn,1,1
ypcount=rs.recordcount
rs.close
'展会
rs.open "select * from SMT_exhibit where SMT_key<>0 and SMT_key2=1",conn,1,1
zhcount=rs.recordcount
rs.close
'信息
rs.open "select * from SMT_xxnews where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
newscount=rs.recordcount
rs.close
'信息
rs.open "select * from SMT_news where SMT_key=1 and SMT_key1=1 and SMT_key2=1",conn,1,1
newscount=rs.recordcount+newscount
rs.close%>