% Response.Buffer=True %>
<% set rs=server.createobject("adodb.recordset")
sql="select * from company"
rs.open sql,conn,1,1
r1=rs.recordcount
rs.close
set rs=nothing
set rs=server.createobject("adodb.recordset")
sql="select * from company where job<>'""' order by id desc"
rs.open sql,conn,1,1
jobnum=rs.recordcount %>