sql server 2000 +aspÍøÕ¾7¸öСʱºó³öÎÊÌâ
×Ô´ÓÖ±½ÓÔÚÒ»¸ö±íÀï¼ÓÁ˸ö×ֶΣ¨nvarchar ÆäËûĬÈÏ£¬²»²åÈë×Ô¼ºÄ¬ÈÏΪ <null>£©ºó,ÖØÆôÍøÕ¾+sql server 2000 6-8¸öСʱºó³öÏÖÎÊÌâ£ºÍøÕ¾Ð´Êý¾Ý¿âʱ½Å±¾³¬Ê±
Active Server Pages ´íÎó 'ASP 0113'
½Å±¾³¬Ê±
µ¼ÖÂÕû¸öÍøÕ¾cpuÕ¼Óôï50%£¬±ØÐëÖØÆôÍøÕ¾¡¢Êý¾Ý¿â²ÅÄÜÕý³£,ÄѵÀÊǶÔÊý¾Ý¿âÓÐÎó²Ù×÷£¿¼ÇµÃÖ»ÓÃÖ´Ðйý²éѯÓï¾ä°¡
ÊDz»ÊÇASP´úÂëÓÐÎÊÌâ,°ÑÖ´ÐеĴúÂëÌù³öÀ´¿´¿´
Êý¾Ý¿âÁ¬½ÓºÍ¼Ç¼¼¯ÓÐûÓм°Ê±¹Ø±Õ²¢ÉèΪNothing£¿
³ÌÐòûÓиĹý£¬Ö»¸ÄÁËÊý¾Ý¿â£¬ÒòΪ¸ÄµÄÖ»ÊDzâÊÔµÄÍøÕ¾£¬¸ÄÍêµÄ»¹Ã»ÉÏ´«£¬Ö»ÓÃͬһ¸öÊý¾Ý¿â²âÊÔ
Ó¦¸Ã²»ÊÇʲô´óÎÊÌâ
´úÂëÎÊÌ⣿»¹ÊÇÉÏ´«×é¼þµÄÎÊÌ⣿ºÃºÃ²é²é°É¡£
Èç¹ûÄãµÄÊý¾Ý¿âºÜ¾Þ´ó¡£°´ÕÕaspµÄÀ¬»ø´¦ÀíÄÜÁ¦£¬²»³öʲŹ֡£
ÔÒò£¬ÄãµÄ×ֶα»¾³£·ÃÎÊ£¬È´Ã»ÓÐ×öË÷Òý
¡¡¡¡ºÍÄã¼ÓµÄÊý¾Ý¿â×Ö¶Îûʲô¹ØÏµ£¬Äã¿ÉÒÔ½øÈësql server¹ÜÀí£¬²é¿´Ò»Ï»µÄÓû§£¬¿´Ò»ÏÂÐÔÄÜ£¬ÕâÑù¾ÍÖªµÀÊý¾Ý¿âÐÔÄܵÄÎÊÌâ¡£
¡¡¡¡¿´¿´ÄãµÄÍøÕ¾ÊDz»ÊDZ»²åÈëÁËľÂí³ÌÐò£¡
cpuÕ¼Óôï50%
ÊDz»ÊÇÓеط½ÏÝÈëËÀÑ»·µ±ÖÐŶ£¡
´úÂëÓÐÎÊÌâ
´úÂë.
Ïà¹ØÎÊ´ð£º
<%if request.QueryString("start") <>"" then%>
<%if cint(start)>0 then%>
<a href="search.asp?q= <%=q%>&start= <%if request.Query ......
ÏÖÔÚÕâÉç»á»ù±¾Éϲ»ÐèÒªASP³ÌÐòÔ±ÁË,Ò»ÃæÊÔ,¶¼Òª.NET»òÕßPHP,JSPµÄ,°¥,,,,ASPÕâô²»ÖµÇ®Âð,ѧϰASPÊǸö´íÎóÂð
ûɶ´íÎó Ò»¾ä»°£º¼¼¶à²»Ñ¹Éí
¿¿ASP¶¼»ì²»µ½·¹³ÔÁË ÔÎ ÔÎ
ÎÒµÄÒâ˼ÊǶàѧһÃż¼Êõûɶ´íÎó ......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
Replaceº¯ÊýÈçºÎĬÈÏÊÇ´Ó×ó¶ËÌæ»»£¬ÈçºÎʹÆä´ÓÓұ߿ªÊ¼Ìæ»»£¬¼´Ìæ»»Ò»¸ö×Ö·û´®µÄ×îºóÒ»¸ö×Ö·û£¬Ìæ»»´ÎÊýΪ1´Î£¬Ð»Ð»
ÒýÓÃ
VBScript code <%
Response.Write ReplaceRev("abcdefXXXghi"," ......