sql server 2000 +aspÍøÕ¾7¸öСʱºó³öÎÊÌâ
×Ô´ÓÖ±½ÓÔÚÒ»¸ö±íÀï¼ÓÁ˸ö×ֶΣ¨varchar ÆäËûĬÈÏ£¬²»²åÈë×Ô¼ºÄ¬ÈÏΪ <null>£©ºó,ÖØÆôÍøÕ¾+sql server 2000 6-8¸öСʱºó³öÏÖÎÊÌâ£ºÍøÕ¾Ð´Êý¾Ý¿âʱ½Å±¾³¬Ê±
Active Server Pages ´íÎó 'ASP 0113'
½Å±¾³¬Ê±
µ¼ÖÂÕû¸öÍøÕ¾cpuÕ¼Óôï50%£¬±ØÐëÖØÆôÍøÕ¾¡¢Êý¾Ý¿â²ÅÄÜÕý³£,ÄѵÀÊǶÔÊý¾Ý¿âÓÐÎó²Ù×÷£¿¼ÇµÃÖ»ÓÃÖ´Ðйý²éѯÓï¾ä°¡
yes
SQL code:
Êý¾Ý¿â±íÖжÁÈ¡¼Ç¼¹ý¶à£¬ÄãµÄSQLÓï¾äûÓÐÓÅ»¯£¬»úÆ÷·ÃÎÊËÙ¶ÈÌ«Âý¶¼»á³öÏÖÕâÑùµÄÎÊÌ⣬°ÑSQLÓï¾äÓÅ»¯Ò»Ï£¬SQLServer µÄ»°Óô洢¹ý³Ì½â¾ö
Ï£ÍûÏÂÃæ·½·¨¿ÉÒÔ°ïÄã½â¾ö´ËÎÊÌâ
·½·¨Ò»
¿ÉÒÔÔö¼Óʱ¼äËùÔÊÐí½øÐÐ ASP ½Å±¾¶ÔÌØ¶¨ÍøÕ¾¡£ ÒªÕâÑù, ½« Internet Information Server (IIS) ÔªÊý¾Ý¿âÖµ£º
1. ´ò¿ª Internet ·þÎñ¹ÜÀíÆ÷¡£
2. Õ¹¿ªÊ÷²¢ÓÒ»÷ ĬÈÏ Web Õ¾µã £¨»ò¾ßÓÐÎÊÌâÕ¾µã£©¡£
3. µ¥»÷ ÊôÐÔ ¡£
4. µ¥»÷ Ö÷Ŀ¼ Ñ¡Ï¡£
5. ÔÚ Ó¦ÓóÌÐòÉèÖà , µ¥»÷ ÅäÖà ¡£
6. µ¥»÷ App Ñ¡Ïî Ñ¡Ï¡£
7. ASP ½Å±¾³¬ ÖµÔö¼Óµ½Êý×ÖÒÔ·ÀÖ¹½Å±¾³¬Ê±×ã¹»¸ß¡£
·½·¨¶þ
¿ÉÒÔÔö¼ÓÔÊÐí¶ÔËùÓÐ Web Õ¾µã½øÐÐ ASP ½Å±¾Ê±¼ä¡£ ÒªÕâÑù, ½«ÔÚ IIS ÔªÊý¾Ý¿âÖµ
1. ´ò¿ª Internet ·þÎñ¹ÜÀíÆ÷¡£
2. ÓÒ¼üµ¥»÷¼ÆËã»úµÄÃû³Æ¡£
3. µ¥»÷ ÊôÐÔ ¡£
4. Ö÷ÊôÐÔ , ÖÐÑ¡Ôñ WWW ·þÎñ , È»ºóµ¥»÷ ±à¼ ¡£
5. µ¥»÷ Ö÷Ŀ¼ Ñ¡Ï¡£
6. ÔÚ Ó¦ÓóÌÐòÉèÖà , µ¥»÷ ÅäÖà ¡£
7. µ¥»÷ App Ñ¡Ïî Ñ¡Ï¡£
8. ASP ½Å±¾³¬ ÖµÔö¼Óµ½Êý×ÖÒÔ·ÀÖ¹½Å±¾³¬Ê±×ã¹»¸ß¡£
·½·¨Èý
Server.ScriptTimeOut ÊôÐÔ¿ÉÓÃÓÚ±à³ÌÔö¼Ó ScriptTimeOut ÊôÐÔÖµÔÚ ASP ÖÐÒ³¼¶±ð¡£ ÀýÈç, Èç¹ûÐèÒª 3 ·ÖÖÓÒÔ´«µ
Ïà¹ØÎÊ´ð£º
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
ÓÉÓÚ¶ÔÒ³ÃæÊ¹ÓÃÁËα¾²Ì¬
²¢ÇÒ¶ÔID½øÐÐÁ˼ÓÃÜ¡£
Ö÷Òª´úÂëÈçÏ£º
httpd.ini
RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I]
³ÌÐò´úÂë
AΪ¼ÓÃÜ£¬BΪ½âÃܺ¯Êý
<a href=&q ......
ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->
<ol>
<%
Set rs=server.CreateObject("adodb.recordset") & ......
owc11Âú×ã²»ÁËÒªÇó£¬ÓÐûÓиüºÃµãµÄ£¬aspÄܵ÷ÓõÄ
Ŀǰû·¢ÏÖ£¬°ïÄã¶¥£¡
Ó¦¸ÃûÓÐÁ˰É
×ÔÒÑд¡£¶¥
°ï¶¥£¬¹Ø×¢£¡
ºÃÏñ¾ÍÕâ¸öÁË£¬Ä¿Ç°»¹Ã»¿´µ½ÆäËûµÃÉÏÊÐʹÓᣡ£¡£°ï¶¥£¡
×Ô¼ºÔÙ¶¥Ò»ÏÂ
ºÃÏñÊÇûÓÐ ......