ACTIVE SERVER PAGE > °Ô½ÃÆÇ - ¸®½ºÆ®ÆäÀÌÁö ¿ª¼ø ³Ñ¹ö °è»ê
µî·ÏÀÏ : 2017-07-03 20:14
Á¶È¸¼ö : 52,947
°Ô½ÃÆÇÀ» ¸¸µé´Ù º¸¸é board_idx °ªÀ» ¹øÈ£·Î Âï½À´Ï´Ù.
±Ùµ¥, Áß°£±ÛÀÌ Áö¿öÁ³À» °æ¿ì ¹øÈ£°¡ ºñ¾î ÀÖ°Ô µË´Ï´Ù. ÀÌ·±°æ¿ì¿¡´Â °è»ê¿¡ ÀÇÇؼ ¹øÈ£¸¦ ȸ鿡 Ãâ·ÂÇϸé
µË´Ï´Ù.
¾Æ·¡ ¼Ò½º¸¦ ³Ñ¹ö¸µÇÏ´Â °è»êÀÌ µé¾î ÀÖ½À´Ï´Ù.
if request("page")="" then page=1 Else page=Request("page") end if
if request("nowblock")="" then nowblock=0 Else nowblock=Request("nowblock") End If
strSql = "select * from board orer by board_idx desc"
objRs.PageSize = 15
objRs.Open strSql, objCnn, 3
if objRs.BOF or objRs.EOF Then
Response.write "±ÛÀÌ Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù"
else
totalpage = objRs.pagecount
objRs.absolutepage = page
recordcount = objRs.recordcount
cnt1 = recordcount Mod 15
list_cnt = cint(totalpage-page)*15 +cnt1
i = 1
Do until objRs.EOF Or i>objRs.PageSize
order_idx = objRs("order_idx")
m_id = objRs("m_id")
order_title = objRs("order_title")
order_writeday = objRs("order_writeday")
order_name = objRs("order_name")
...... ¸®½ºÆ® Ãâ·Â ºÎºÐ
response.write list_cnt '³Ñ¹ö Ãâ·Â
list_cnt = list_cnt - 1
i=i+1
objRs.MoveNext
Loop
End if
objRs.close
Áß°£ »¡°£»öÀÇ ¼Ò½º¿¡¼ ¾Æ·¡ºÎºÐ¸¸ º¸¸é µÇ½Ã°Ú³×¿ä.
cnt1 = recordcount Mod 15
list_cnt = cint(totalpage-page)*15 + cnt1
ºÐ¼®Àº ¿©·¯ºÐÀÇ ¸òÀÔ´Ï´Ù.