¹ØÓÚASP Recordset ·ÖÒ³³öÏÖ¸ºÊý½â¾ö·½·¨¼°½¨Òé
¶ÔÓÚRecordset·Öҳʱ³öÏÖ¸ºÊýµÄÏÖÏó£¬ÏàÐÅ»áÓкܶàÈËÓöµ½¹ýÕâ¸öÎÊÌ⣬ÓÐʱ°Ù¶È¡¢GOOGLEÒ²²»µÃÆä½â£¬ÏÖÔÚÓÉÎÒÀ´×ܽáһϡ£
³öÏÖ¸ºÊý£¬Ö÷ÒªºÍÓαêÀàÐÍÓйØÏµ¡££¨Îª¾ÙÀý·½±ã£¬¼ÙÉèÒѾÓÐÒ»¸öconn.aspÁ´½ÓÊý¾Ý¿âµÄÎļþ²¢ÇÒÒѾinclude£©ÏÖÔÚ¾ÙÒ»¸öÀý×Ó£¬´úÂëÈçÏ£º
'=======================================================
sql="Select * from ±íÃû where Ìõ¼þ order by ID desc" 'ÕâÀïµÄorder by Ìõ¼þ¿É¸ù¾Ý×Ô¼ºÐèÒª¸Äд
Set rs=conn.execute(sql) '===×¢ÒâÒ»ÏÂÕâÒ»¾ä===
rs.pagesize=10 '===ÉèÖÃÿҳµÄ¼Ç¼ÊýΪ10===
page=request.querystring("page")
If page="" Then page=1
If Not IsNumeric(page) Then page=1
page=clng(page)
If page<1 Then page=1
If page>rs.pagecount Then page=Vrs.pagecount
rs.absolutepage=page
dim c
c=1
Do while Not rs.eof And c<=rs.pagecount
'Êä³öÄÚÈÝ
c=c+1
rs.movenext
Loop
'×öÒ³ÃæµÄÁ´½Ó
'=======================================================
¸ù¾ÝÉÏÃæµÄ´úÂ룬RecordSet¶ÔÏóÖ±½ÓÓÉ´úÂ룺Set rs=conn.execute(sql)£¬Ê¹Óøþäºó£¬RecordSe
Ïà¹ØÎĵµ£º
½ÌѧÄÚÈÝ
ASP¶¯Ì¬ÍøÒ³Éè¼Æ¼¼ÊõÌåϵ½á¹¹
ASPÖ÷Òª¹¹³ÉÔªËØµÄ¹¦Äܼ°Ó÷¨
ASP¶¯Ì¬ÍøÒ³Éè¼ÆÊµÀý
ÖØµãºÍÄѵã
asp¶¯Ì¬ÍøÒ³Éè¼Æ¼¼ÊõÌåϵ½á¹¹
asp¶¯Ì¬ÍøÒ³Éè¼ÆµÄ·½·¨
ǰµ¼ÖªÊ¶
½Å±¾ÓïÑÔ——vbscript»òjavascript
Êý¾Ý¿â֪ʶ——SQL
²ÎÔÄ×ÊÁÏ
HTTP://WWW.w3schools.com
ÍÆ¼öÈí¼þ£ºAdobe Dreamweaver ......
º¯Êý Óï·¨ ¹¦ÄÜ
Len Len(string|varname) ·µ»Ø×Ö·û´®ÄÚ×Ö·ûµÄÊýÄ¿£¬»òÊÇ´æ´¢Ò»±äÁ¿ËùÐèµÄ×Ö½ÚÊý¡£
Trim Trim(string) ½«×Ö·û´®Ç°ºóµÄ¿Õ¸ñÈ¥µô
Ltrim Ltrim(string) ½«×Ö·û´®Ç°ÃæµÄ¿Õ¸ñÈ¥µô
Rtrim Rtrim(string) ½«×Ö·û´®ºóÃæµÄ¿Õ¸ñÈ¥µô
Mid Mid(string,start,length) ´Óstring×Ö·û´®µÄstart×Ö·û¿ªÊ¼È¡µÃlength³¤¶ ......
ASPÓëÊý¾Ý¿âÓ¦ÓÃ(¸ø³õѧÕß)
--------------------
¼û×î½üÐí¶àÍøÓÑѯÎÊһЩ¹ØÓÚÊý¾Ý¿â²Ù×÷µÄ»ù´¡ÎÊÌ⣬ÏÖ°ÑÎÒÒÔǰдµÄһƪ¼òµ¥½Ì³ÌÌùÉÏÀ´£¬ºÃÈÃһЩ³õѧÕß×î¿ìµÄÈëÃÅ£º
ASPÓëÊý¾Ý¿âÓ¦Ó㨸ø³õѧÕߣ©
Ò»°ãÀ´Ëµ£¬Ò»¸öÕæÕýµÄ¡¢ÍêÕûµÄÕ¾µãÊÇÀë²»¿ªÊý¾Ý¿âµÄ£¬ÒòΪʵ¼ÊÓ¦ÓÃÖУ¬ÐèÒª±£´æµÄÊý¾ÝºÜ¶à£¬¶øÇÒÕâЩÊý¾ÝÖ®¼äÍùÍù»¹ ......
VBSÀ³¬³öIntegerÀàÐ͵Äȡֵ·¶Î§£¬¸ÃÀàÐ͵Äȡֵ·¶Î§Îª-32,768 µ½ 32,767 Ö®¼äµÄÕûÊý¡£
³ö´íµÄ¸ùÔ´£º
ÔÚASPÀÓÐʱºòΪÁË·ÂÖ¹×¢È룬ËùÒÔÔÚ½ÓÊÕ²ÎÊýµÄʱºòÖ±½ÓʹÓÃCintº¯Êý°Ñ½Ó¹ýÀ´µÄ²ÎÊýת»»ÎªInteger£¨Êý×Ö£©ÀàÐÍ£¬Õâ¾Í´æÔÚÒ»¸öDZÔÚÎÊÌ⣬µ±Ò³Ãæ½ÓÊÕµÄij¸ö²ÎÊý£¨Request("xxx")£©³¬¹ýȡֵ·¶Î§Ê±£¨¿É¼òµ¥Àí½âΪ5λÊý×Ö£ ......
½ñÌìÔÚÓÃutf-8±àÂëÓÃÔÚеÄÍøÕ¾ÉÏ£¬²»ÏëÎÊÌâ»¹Õæ¶à£¬ËùÒÔÕÒÁËЩÎÄÕ£¬Ìû×Ó£¬¿´ÁË¿´£¬µÈÏÂÓÐÓõľÍÌùÏÂÃæÁË¡£
½ñÌ죬ÎÒ¿ªÊ¼°Ñ CODEPAGE="936" ¸Ä³É CODEPAGE="65001"
°Ñcharset=gb2312¸Ä³É charset=utf-8
¿ÉÊÇ»¹ÊÇÂÒÂ룬ֻҪÊǽű¾Óõĵط½»¹ÊÇÂÒÂ룬ÏÖÔÚÖÕÓÚÕÒµ½ÎÊÌâÁË£¬¾ÍÊǵ±½Å±¾Êä³öʱºò£¬ÒªÒÔutf-8±àÂëÊä³ö¡£
¾ÍÊÇ ......