一些Asp技巧和實用解決方法 隨機數: <%randomize%> <%=(int(rnd()*n)+1)%> 查詢數據時得到的記錄關鍵字用紅色顯示: <% =replace(RS("字段X"),searchname,"<font color=#FF0000>" & searchname & "</font>") %> 通過asp的手段來檢查來訪者是否用了代理 <% if Request.ServerVariables("HTTP_X_FORWARDED_FOR")<>"" then response.write "<font color=#FF0000>您通過了代理服務器,"& _ "真實的IP為"&Request.ServerVariables("HTTP_X_FORWARDED_FOR") end if %> 判斷上一頁的來源 request.servervariables("HTTP_REFERER") javascript: document.referrer 清除緩存,重新加載頁面 <%response.expires = 0 response.expiresabsolute = now() - 1 response.addHeader "pragma","no-cache" response.addHeader "cache-control","private" Response.cachecontrol = "no-cache" %> 在下拉菜單中顯示年和月 <select name="select"> <% Dim M_Year Dim M_Month Dim M_MonthJ Dim M_TheMonth Dim M_YM For M_Year = 2000 To Year(Date) M_Month = 12 If M_Year = Year(Date) Then M_Month = Month(Date) End If For M_MonthJ=1 To M_Month If M_MonthJ < 10 Then M_TheMonth = "0" & M_MonthJ Else M_TheMonth = M_MonthJ End If M_YM = M_Year& "-" & M_TheMonth %> <option value="<%= M_YM %>"><%= M_YM %></option> <% Next Next %> </select> 檢索并刪除數據庫里的重復記錄 conn.execute("delete from table where id not in (select distinct from table)")
|