½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
asp
CSS
html
mysql
jquery
image
Mobile
API
slide
°Ô½ÃÆÇ
¸Þ´º
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 122 | Á¶È¸¼ö 1,473 | µî·ÏÀÏ 2003-11-03 19:25:53

´Ð³×ÀÓ

kocktail

À̸ÞÀÏ

kocktail76@daum.net

Á¦¸ñ

µµ´ëü ¿Ö ¿¡·¯ÀÎÁö ¸ð¸£°Ú¾î¿ä ¤Ì¤Ì µµ¿ÍÁÖ¼¼¿ä
³»¿ë

¿À·ù Çü½Ä:
ADODB.Recordset (0x800A0CB3)
°³Ã¼ ¶Ç´Â °ø±ÞÀÚ°¡ ¿äûÇÑ ÀÛ¾÷À» ¼öÇàÇÒ ¼ö ¾ø½À´Ï´Ù.
============================================

<%
  if request("PageNo")="" then
      PageNo=1
   else
      PageNo=CInt(Request("PageNo"))
   end if
 
  strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\LoginOri.mdb"
  Set db = Server.CreateObject("ADODB.Connection")
  db.Open strCon
  Set rs = Server.CreateObject("ADODB.Recordset") 
  rs.open "select * from notice order by n_id desc",db,adOpenStatic
   
 
      if(rs.BOF=True and rs.EOF=True) then
     Record_Null=1
    else
     BlockSize=10
 rs.PageSize = 1
 PageSize = rs.PageSize
 PageCount = rs.PageCount
 RecordCount = rs.RecordCount
 BlockNo = ( PageNo + (BlockSize-1 ) ) \ BlockSize
 rs.AbsolutePage = PageNo                  <=======================ÀÌ ºÎºÐÀÌ ¿À·ù ºÎºÐÀÔ´Ï´Ù.
 StartPage = ( (BlockNo-1)*BlockSize)+1
 if PageCount > (BlockNo*BlockSize) then
 EndPage = (BlockNo*BlockSize)
 else
 EndPage = PageCount
 end if
    end if
   
    if PageNo < 1 OR PageNo > PageCount then
    Page_Null = 1
    else
    Page_Null = 0
    end if
    table_page_size = 10
%>

==============================================

µµ´ëü ¿Ö ¿¡·¯ÀÎÁö ¸ð¸£°Ú¾î¿ä ¤Ì¤Ì µµ¿ÍÁÖ¼¼¿ä

 

Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
HappyCGI 2003-11-04 12:17:53
´ä±Û

Á˼ÛÇÕ´Ï´Ù. ÀúÈñÆÀÀÌ Àß ¸ð¸£´Â ¾ð¾îÀÔ´Ï´Ù.

ÀÌÀü°Ô½Ã±Û select¹®À¸·Î ´Ù¸¥ ÇÁ·¹ÀÓ¿¡ ¹®¼­¸¦ ¿­À»·Á°í Çϴµ¥ ¤Ì¤Ì 2003-10-31 23:48:29
´ÙÀ½°Ô½Ã±Û Ä«Å×°í¸®º°·Î ºÐ·ùÇϴ°Í..perl·Î 2003-11-04 10:38:24