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=")
......
ÎÒÓÐÒ»¸öaspÔ´Â룬µ«ÊdzöÏÖÒ»¸öÎļþ£¬ÎÒÓÃasp½âÃܶ¼ÊÇÂÒÂë
Çë½Ì
VBScript code:
??
%# , #&')*)-0-(0%()(?
(((((((((((((((((((((((((( ......
ÎÒµÄ網頁´ú碼為ASP語ÑÔ,驗證·½Ê½為ϵ統×Ô帶µÄWINDOW驗證ģʽ.
現ÔÚÎÒÈç¹ûÒªÔÚASP´ú碼ÖÐ獲È¡當ǰµÄµÇÈëÈË ......
ÎÒÏëÓÃaspд¸öÒ³ÃæÒÔǰûÓнӴ¥¹ý£¬ÎÒ¿´ÍøÉÏ˵aspµÄÔËÐл·¾³Ö»ÄÜÊÇwindows£¬»¹±ØÐëҪװIIS¡£
Çë½Ì¸÷λ¸ßÊÖ£¬asp»¹ÓÐÆäËûµÄÔËÐл·¾³Âð?
²î²»¶à¾ÍÕâЩÁË£¬¾ÍÊÇIISÒ»¶¨Òª×°ºÃ
»¹ÓÐÒªÊÇÓÃVS2005µÄ»°ºÃÏñ¿ÉÒÔÖ±½ÓÔ ......
ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->
<ol>
<%
Set rs=server.CreateObject("adodb.recordset") & ......