22,209
社区成员
发帖
与我相关
我的任务
分享
dim rs,sql,Pagesize,Allrecord,Allpage,Page,id,rs1,sql1,zt,degree,dysp,thepage
dim cmdTemp
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs = server.CreateObject ("adodb.recordset")
condition = get_search_data()
'response.Write condition
'response.End()
sql = "select jobs.id as id,jobs.comid as comid,jobs.jobs as jobs,jobs.dysp as dysp,jobs.s_WorkLocation as s_WorkLocation,jobs.c_worklocation as c_worklocation,jobs.endValidDate as endValidDate,jobs.tjsj as tjsj,jobs.zt as zt,jobs.topall as topall,jobs.topdate as topdate,jobs.topday as topday,jobs.ispub as ispub,jobs.ischeck as ischeck,company.vip as vip,company.companyname as companyname from [jobs] left join [company] on jobs.comid=company.comid where 1=1 "&condition&" order by jobs.id desc"
cmdTemp.CommandText = sql
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn
rs.Open sql,conn,1,3
set cmdTemp=nothing
rs.Pagesize=15
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
page = getpage(request("page"))
thepage=(page-1)*pagesize
if not rs.eof then rs.absolutepage=page