aspÄÜÖ´Ðж¯Ì¬T-SQLÂð£¿
Ö±½ÓÔÚsqlÓï¾äÖÐд£º
sql= " declare @1 nvarchar(max),@2 nvarchar(max£©...... "
È»ºó
Rs.open sql,CONN,3,2
Response.Write Rs.recordcount
µ«ÊÇûÓдò¿ª£¬±¨´í
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
ÊDz»ÊÇÒªÓô洢¹ý³Ì²Å¿ÉÒÔѽ£¿
ÔÚasp.netÖÐÊÇ¿ÉÒÔÖ±½ÓÔÚsqlÀïÃæÄÇÑùдµÄ¡£
³Ô·¹»ØÀ´¹Ø×¢¡£
CONN.execute sql
²»ÐÐ ¡£
»¹ÊDZ¨´í
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
²Ù×÷±»¾Ü¾ø£¡ÔÚ¶ÔÏóÒѹرյÄʱºò
±¨Ê²Ã´´í?
Á¬½Ó´®µÄÕʺÅÒªÓÐ×ã¹»µÄȨÏÞÖ´ÐвÙ×÷
ÒÔϲâÊÔ¿ÉÒÔ
VBScript code:
sql= " declare @1 nvarchar(max), @2 nvarchar(max);"
Set conn = CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data source=127.0.0.1;Initial Catalog=DB;User ID=sa;Password=sa;"
conn.Execute sql
conn.Close
{{---
Ïà¹ØÎÊ´ð£º
<%@language="vbscript"%>
<%option explicit%>
<html>
<head> <title>xxx </title> </head>
<script language=vbs>
'×¢Òâ±äÁ¿ ......
ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......
<%if request.QueryString("start") <>"" then%>
<%if cint(start)>0 then%>
<a href="search.asp?q= <%=q%>&start= <%if request.Query ......
½¨ÁËÒ»¸öÕ¾µã£¬ÀïÃæÓÐ login.aspx. events.aspx µÈµÈ ÆäËûµÄÒ³Ãæ¡£
µ«ÊÇÎÒµ÷ÊÔ ÆäËûÒ³ÃæµÄʱºò£¬±Ä³öÀ´µÄ×ÜÊÇ login.aspx Ò³Ãæ¡£
¸Õѧasp ÇëÖ¸½Ì
ÄãÉèÖÃÆðʼҳÁ˰ɡ£¡£
¶÷ÔõôȡÏûÄØ£¿
Òªµ ......
ÎÒ°ïѧУ×öÁËÒ»¸öÕ¾£®
ÔÚÐ£Ô°ÍøµÄÇé¿öÏ£¬Äܹ»µÇ½³É¹¦£¬ºǫ́ÕʺŶ¼ÄÜͨ¹ý£¬½øÈëºǫ́
µ«ÊÇÔÚÍâÍø£Á£ÄµÄÇé¿öÏ£¬Äܹ»µÇ½ºǫ́µÄÒ³Ãæ£¬Ò³ÃæÊÇ£Á£Ó£ÐÎļþ£®
µ«ÊÇÊäÈëÕʺźÍÃÜÂëµÄʱºò£¬ÍøÒ³ÔËÐкܾö¼ ......