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
- - Óï·¨...
Ïà¹ØÎÊ´ð£º
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
½¨ÁËÒ»¸öÕ¾µã£¬ÀïÃæÓÐ login.aspx. events.aspx µÈµÈ ÆäËûµÄÒ³Ãæ¡£
µ«ÊÇÎÒµ÷ÊÔ ÆäËûÒ³ÃæµÄʱºò£¬±Ä³öÀ´µÄ×ÜÊÇ login.aspx Ò³Ãæ¡£
¸Õѧasp ÇëÖ¸½Ì
ÄãÉèÖÃÆðʼҳÁ˰ɡ£¡£
¶÷ÔõôȡÏûÄØ£¿
Òªµ ......
ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->
<ol>
<%
Set rs=server.CreateObject("adodb.recordset") & ......
ÎÒÓÐÒ»¸öÎļþÃû aaa.bbb.rar»òÕßa.b.c.d.html»òÕßaa.b.dd.shtml
ÎÒÔõÑù½ØÈ¡ÎļþµÄºó׺Ãûѽ¡£¡£¡£
<%
aa="aaa.bbb.rar"
bb=split(aa,".")
response.write bb(ubound(bb)) ......
×Ö¶ÎPowerListÀïÃæµÄÖµ£ºKSO10000,KSO10021,KSO10004,KSO10022,KSO10020,KSO10008
ÏÖÔÚÒªÅжϣ¬µ±PowerListÀïÃæ´æÔÚKSO10004Õâ¸öÖµµÄʱºò£¬Êä³ö£ººÃ
VBScript code:
<%
set rs=server.Creat ......