%
if request("page") = "" then
page = 1
else
page = int(request("page"))
end if
category = int(request("category"))
if category = "" or NOT ctype(category) = 4 then
errorbox("카테고리가 잘못되었습니다")
end if
word = request("word")
sc = int(request("sc")) '1:제목,2:내용,3:작성자
Set rs1 = Server.CreateObject ("ADODB.recordset")
sql = "select * from board where category = "&category
if word <> "" then
if sc = 1 then
sql = sql&" and title like '%"&word&"%'"
elseif sc = 2 then
sql = sql&" and content like '%"&word&"%'"
elseif sc = 3 then
sql = sql&" and name like '%"&word&"%'"
end if
end if
sql = sql&" order by bgroup DESC, bstep ASC"
rs1.PageSize = 10
rs1.Open sql, Conn, 3, 3
if not rs1.EOF or not rs1.BOF then
totalart=rs1.RecordCount
totalpage=rs1.pagecount
rs1.AbsolutePage = page
bunchnum=((page-1)-((page-1) MOD 10))/10 '페이지 묶음에 따른 묶음 번호.
else
totalart = 0
totalpage = 0
end if
%>
<% Set rs1 = nothing%>