ASPµÄÊý¾Ý¼¯¿É²»¿ÉÒÔÕâÑùд£¿
set rs=server.createobject("adodb.recordset")
set RS=server.createobject("adodb.recordset")
sql1="select jufenjiekou from A"
Rs.open sql1,conn,1,1
while not Rs.eof
sql2="select top 1 * from AE"
rs.open sql2,conn,1,3
²Ù×÷¡£¡£¡£
rs.movenext
wend
----------------------------------------------------------------------
ÇëÎÊÕâÑùд¶ÔÂ𣬲Ù×÷Á½¸ö±í
²»ÄÜ,vb´óСд²»Ãô¸ÐrsºÍRSÊÇͬһ¸ö±äÁ¿,
ÇëÎÊÂ¥ÉÏ£¬ÎÒдµÄÓï·¨ÓÐÎÊÌâÂð
Äã¿ÉÒÔÕâÑùд.ASPÀïºÃÏñ²»·Ö´óСдµÄ
VBScript code:
set rs1=server.createobject("adodb.recordset")
set RS=server.createobject("adodb.recordset")
sql1="select jufenjiekou from A"
Rs.open sql1,conn,1,1
while not Rs.eof
sql2="select top 1 * from AE"
rs1.open sql2,conn,1,3
²Ù×÷¡£¡£¡£
rs1.movenext
wend
- - Óï·¨...
Ïà¹ØÎÊ´ð£º
×î½üÎÒͨ¹ýѧϰ£¬¸Ð¾õ×Ô¼ºÑ§µÄ»¹¿ÉÒÔÁË£¬Ïë×öÒ»ÍøÕ¾£¬µ«ÊÇÒ»Ö±¶¼ÕÒ²»µ½Ìâ²Ä£¬²»ÖªµÀ×öʲô£¬Ï£Íû¸÷λ¸øÎÒµãÒâ¼û£¬Èç¹ûÓÐÐèÇóÎĵµ¾Í¸üºÃÁË£¡Ï£Íû´ó¼Ò¸øÎÒµãÒâ¼û£¬Ð»Ð»£¡
ÏÈ×ö¸öÆóÒµÍøÕ¾°É£¬ÎҸоõÒ»¸öÈË×öÍøÕ¾²»ÊÊÒË ......
½¨ÁËÒ»¸öÕ¾µã£¬ÀïÃæÓÐ login.aspx. events.aspx µÈµÈ ÆäËûµÄÒ³Ãæ¡£
µ«ÊÇÎÒµ÷ÊÔ ÆäËûÒ³ÃæµÄʱºò£¬±Ä³öÀ´µÄ×ÜÊÇ login.aspx Ò³Ãæ¡£
¸Õѧasp ÇëÖ¸½Ì
ÄãÉèÖÃÆðʼҳÁ˰ɡ£¡£
¶÷ÔõôȡÏûÄØ£¿
Òªµ ......
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
......
ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->
<ol>
<%
Set rs=server.CreateObject("adodb.recordset") & ......