set rs=server.createobject("adodb.recordset")
sql="select * from SMT_Job_zp where smt_job_name like'%"&JobStyle&"%'and smt_dx like'"&EmployType&"'and smt_dd like '%"&JobAddress&"%'"
rs.open sql,conn,1,1
sql="select * from SMT_Job_zp where smt_job_name like'%"&JobStyle&"%'and smt_dx like'"&EmployType&"'and smt_dd like '%"&JobAddress&"%'"
rs.open sql,conn,1,1