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Ô´Â룬µ«ÊdzöÏÖÒ»¸öÎļþ£¬ÎÒÓÃasp½âÃܶ¼ÊÇÂÒÂë Çë½Ì VBScript code: ?? %# , #&')*)-0-(0%()(? (((((((((((((((((((((((((( ......
ÎÒÏëÓÃaspд¸öÒ³ÃæÒÔǰûÓнӴ¥¹ý£¬ÎÒ¿´ÍøÉÏ˵aspµÄÔËÐл·¾³Ö»ÄÜÊÇwindows£¬»¹±ØÐëҪװIIS¡£ Çë½Ì¸÷λ¸ßÊÖ£¬asp»¹ÓÐÆäËûµÄÔËÐл·¾³Âð? ²î²»¶à¾ÍÕâЩÁË£¬¾ÍÊÇIISÒ»¶¨Òª×°ºÃ »¹ÓÐÒªÊÇÓÃVS2005µÄ»°ºÃÏñ¿ÉÒÔÖ±½ÓÔ ......
ÓÐÄÄλ¸ßÊÖÓùýASP FCKÔÚÏß±à¼Æ÷ѽ£¬ËüÄǸöͼƬÉÏ´«¹¦ÄÜÔõôÅäÖÃѽ ÄܸøÎÒ·¢¸öÄÜÓÃFCKÔÚÏß±à¼Âð£¿Ò»¶¨ÄÜÉÏ´«Í¼Æ¬¹¦ÄܵÄѽ£¬¼±Ñ½ Ö±½Óµ½¹Ù·½ÍøÕ¾È¥Ï¸ö¾Í¿ÉÒÔÁË£¬¹ØÓÚÉèÖÃô£¬Ö±½ÓGOOGLEÒ»ÏÂÄãµÄ°æ±¾ºÅ¾Í¿ÉÒÔÕÒµ ......
<% 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
......
ÔÌû×Ó£ºhttp://topic.csdn.net/u/20090910/12/813a40a2-922d-4f6a-b30b-a16b9a608f81.html?seed=1336087098&r=59699368#r_59699368 ÏÂÃæµÄ´úÂëÓдíÎóÂð£¿sqlÓï¾äÔÚQueryÖÐÊÇ¿ÉÒÔÖ´Ðгö½á¹ûµÄ¡£ Set C ......