% GotoPage = Request("GotoPage") if GotoPage = "" then GotoPage = 1 pagesize = 16 branchCode = Request("branchCode") search_category = Request("search_category") searchString = Request("searchString") 'If branchCode = "" Then branchCode = "" If branchCode <> "" Then search_qry = " and branchCode = '"&branchCode&"'" 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_consult where 1=1 " & search_qry 'Response.write SQL 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_consult " SQL = SQL & " WHERE 1=1 "&search_qry&" and IDX not in " SQL = SQL & "(SELECT TOP " & ((GotoPage - 1) * pagesize) & " IDX FROM tbl_consult" SQL = SQL & " where 1=1 "&search_qry&" ORDER BY IDX desc) order by idx desc" 'Response.write SQL Set RS = Dbcon.Execute(SQL) %>
¹øÈ£ |
![]() |
Á¦¸ñ | 󸮻óÅ | ÀÛ¼ºÀÚ | µî·ÏÀÏ | <% If Session("admin_div") = "1" Then %>µð¹ÙÀ̽º | <% End If %>
---|---|---|---|---|---|---|
<%=view_num%> | <% If branch_Code = "U001" Then %> °³²Á¡ <% End If %> <% If branch_Code = "U003" Then %> Àá½ÇÁ¡ <% End If %> <% If branch_Code = "U005" Then %> Àá½ÇÁ¡ <% End If %> <% If branch_Code = "U006" Then %> ¿Õ½Ê¸®Á¡ <% End If %> <% If branch_Code = "U004" Then %> ÆÇ±³Á¡ <% End If %> <% If branch_Code = "U002" Then %> ¼ö¿øÁ¡ <% End If %> <% If branch_Code = "U007" Then %> ¸íµ¿Á¡ <% End If %> <% If branch_Code = "U008" Then %> ±¤±³Á¡ <% End If %> <% If branch_Code = "U009" Then %> ½ÅÃÌÁ¡ <% End If %> | secret<% End If %>"> <% If bbs_type_u = "1" And Trim(Session("user_id")&"")="" Then %> <%=b_subject%> <% Else %> <%=b_subject%> <% End If %> <% Call getTimeIcon(RS("b_writedate")) %> |
<% If b_reple_type = "0" Then %>
![]() ![]() |
<%=user_name%> | <%=b_writedate%> | <% If Session("admin_div") = "1" Then %><%=RS("device")%> | <% End If %>