<% action = request.querystring("action") if action = "Delete" then emp_id = request.querystring("emp_id") qryDel = "delete from employments where emp_id = "& emp_id &"" set rsDel = conn.execute(qryDel) set rsDel = nothing end if %>
Edit Delete Detail
<% 'qry = "select Month(emp_record) from news" 'set rc = conn.execute(qry) 'do while not rc.eof 'response.write rc(0) & "
" 'rc.movenext 'loop 'set rc = nothing qryNews = "select * from employments order by emp_id desc" set rsInv = conn.execute(qryNews) response.write "Found : " & rsInv.recordcount & " Item(s)" if not rsInv.eof then if request("no") ="" then pageno =1 else pageno=request("no") end if total = rsInv.recordcount pagesize= 10 totalpage = total\pagesize if (total mod pagesize) <> "0" then totalpage= totalpage+1 else totalpage = 0 end if rsInv.Move pagesize*(pageno-1) a=1 if trim(pageno) <> trim(totalpage) then endrecord = pagesize else endrecord=(total mod pagesize) end if For a=1 to endrecord %> <% rsInv.movenext next set rsInv = nothing end if %>
Employment
 Lastest Update
  Head  Preview
Picture
Function
 <%=dateformatshort(rsInv("emp_record"))%> <%=timeformat(rsInv("emp_record"))%>
 <%=rsInv("emp_head")%>
 <%=rsInv("emp_preview")%>   <% if len( rsInv("emp_picture")) > 0 then response.write imgsrc("../" & rsInv("emp_picture"), rsInv("emp_picturex"), rsInv("emp_picturey"), 50, 0) else response.write "-" end if %>
');return document.MM_returnValue"> &action=Delete');return document.MM_returnValue"> ','Detail','scrollBars=yes,toolbar=no,status=yes,resizable=yes,width=768,height=550')">

<%For b=1 to totalpage%> <%=b%> <%Next%>