<% page=request("page") if page="" or not isNumeric(page) then page=1 iPageSize = 12 iPageCurrent=cint(page) sTableName = "Job" strSQL = "SELECT * FROM " &sTableName& " order by category,indexNo,Job_position" Set DataRec = Server.CreateObject("ADODB.RecordSet") DataRec.PageSize = iPageSize DataRec.CacheSize = iPageSize DataRec.Open strSQL, DataConn, adOpenKeyset, adLockPessimistic, adCmdText iPageCount = DataRec.PageCount if iPageCurrent > iPageCount then iPageCurrent = iPageCount if iPageCurrent < 1 then iPageCurrent = 1 %>
Join Our Team

Current Job Opening:

<% if not iPageCount = 0 then DataRec.AbsolutePage = iPageCurrent iRecordsShown = 0 iColumn=0 bgcolor="" Categorytemp="" Do While iRecordsShown < iPageSize And Not DataRec.EOF ID=trim(Datarec("ID")) Job_Position=trim(Datarec("Job_Position")) DESCRIPTION=trim(Datarec("DESCRIPTION")) POSTDATE=trim(Datarec("POSTDATE")) category=datarec("category") email=datarec("email") if not description = "" then if instr(ucase(description ),"") end if ' if len(description )>400 then description =left(description ,400)&" ..." end if if not Categorytemp=category then Categorytemp=category iColumn=0 %> <% end if %> <% DataRec.MoveNext iRecordsShown = iRecordsShown + 1 iColumn=iColumn+1 'if iColumn mod 2 = 0 then response.write "" loop DataRec.Close Set DataRec = Nothing %>
<%=category%>
  <%=Job_Position%> :
<%=description%>