Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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

²»ÐÐ ¡£

ÒýÓÃ
CONN.execute sql


»¹ÊDZ¨´í
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.

ÒýÓÃ
ÒýÓà 2 Â¥ hookee µÄ»Ø¸´:
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


{{---


Ïà¹ØÎÊ´ð£º

ASP¼òµ¥ÎÊÌâ

conn.asp

<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath("Connt ......

aspÊÂÎñÎÊÌâ

<%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α¾²Ì¬µÄÁíÀàÎÊÌâ

ÓÉÓÚ¶ÔÒ³ÃæÊ¹ÓÃÁËα¾²Ì¬
²¢ÇÒ¶ÔID½øÐÐÁ˼ÓÃÜ¡£
Ö÷Òª´úÂëÈçÏ£º
httpd.ini
RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I]

³ÌÐò´úÂë
AΪ¼ÓÃÜ£¬BΪ½âÃܺ¯Êý
<a href=&q ......

ASP FCKÔÚÏ߱༭Æ÷

ÓÐÄÄλ¸ßÊÖÓùýASP FCKÔÚÏ߱༭Æ÷ѽ£¬ËüÄǸöͼƬÉÏ´«¹¦ÄÜÔõôÅäÖÃѽ
ÄܸøÎÒ·¢¸öÄÜÓÃFCKÔÚÏ߱༭Âð£¿Ò»¶¨ÄÜÉÏ´«Í¼Æ¬¹¦ÄܵÄѽ£¬¼±Ñ½
Ö±½Óµ½¹Ù·½ÍøÕ¾È¥Ï¸ö¾Í¿ÉÒÔÁË£¬¹ØÓÚÉèÖÃô£¬Ö±½ÓGOOGLEÒ»ÏÂÄãµÄ°æ±¾ºÅ¾Í¿ÉÒÔÕÒµ ......

ÈçºÎÖÆ×÷aspÊÔÓðæ?

Ò»¶Îʱ¼äºó ¾Í²»ÄÜÓõÄÄÇÖÖ

¿ÉÒÔÓÃ×é¼þдÂð?
×é¼þ  ÊDz»ÊDZØÐëÏÈÔÚ·þÎñÆ÷°²×°  ²ÅÄÜʹÓÃ?

ÄÇÓÃÐéÄâÖ÷»úµÄ  ²»¾ÍûϷÁË....

ewebeditor¾ÍÊÇҪע²á²ÅÄÜÓõĠ
Ã²ËÆÊÇûɶÓõ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ