% GotoPage = Request("GotoPage") if GotoPage = "" then GotoPage = 1 pagesize = 16 store_typev = Request("store_type") search_category = Request("search_category") searchString = Request("searchString") If store_typev = "" Then store_typev = 0 If store_typev <> "0" Then search_qry = " and store_type = '"&store_typev&"'" End If If search_category <> "" And searchString <> "" Then search_qry = " and "&search_category&" like '%"&searchString&"%'" End If SQL = "SELECT count(IDX) as recCount FROM tbl_incruit where 1=1 " & search_qry SET Rs = DBCON.EXECUTE(SQL) recordCount = Rs(0) Rs.close : Set Rs = nothing pagecount = int((recordCount-1)/pagesize) +1 SQL = "SELECT TOP " & pagesize & " * FROM tbl_incruit " SQL = SQL & " WHERE 1=1 "&search_qry&" and IDX not in " SQL = SQL & "(SELECT TOP " & ((GotoPage - 1) * pagesize) & " IDX FROM tbl_incruit" SQL = SQL & " where 1=1 "&search_qry&" ORDER BY IDX desc) order by idx desc" Set RS = Dbcon.Execute(SQL) %>
¹øÈ£ |
ä¿ëºÐ¾ß![]() |
Á¦¸ñ | ÀÛ¼ºÀÚ | µî·ÏÀÏ |
---|---|---|---|---|
<%=view_num%> | <% If store_type = "1" Then %> °£È£Á¶¹«»ç <% End If %> <% If store_type = "2" Then %> °ü¸®»ç <% End If %> <% If store_type = "3" Then %> ÄÚµð³×ÀÌÅÍ <% End If %> | <% If bbs_type_u = "1" And Trim(Session("id")&"")="" Then %> <%=b_subject%> <% Else %> <%=b_subject%> <% End If %> | <%=user_name%> | <%=b_writedate%> |