一些Asp技巧和實用解決方法

一些Asp技巧和實用解決方法

隨機數:

<%randomize%>

<%=(int(rnd()*n)+1)%>

查詢數據時得到的記錄關鍵字用紅色顯示：

<%=replace(RS("字段X"),searchname,"<fontcolor=#FF0000>"&searchname&"</font>")%>

通過asp的手段來檢查來訪者是否用了代理

<%ifRequest.ServerVariables("HTTP_X_FORWARDED_FOR")<>""then

response.write"<fontcolor=#FF0000>您通過了代理服務器，"&_

"真實的IP為"&Request.ServerVariables("HTTP_X_FORWARDED_FOR")

endif

%>

判斷上一頁的來源

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"

%>

在下拉菜單中顯示年和月

<selectname="select">

<%

DimM_Year

DimM_Month

DimM_MonthJ

DimM_TheMonth

DimM_YM

ForM_Year=2000ToYear(Date)

M_Month=12

IfM_Year=Year(Date)Then

M_Month=Month(Date)

EndIf

ForM_MonthJ=1ToM_Month

IfM_MonthJ<10Then

M_TheMonth="0"&M_MonthJ

Else

M_TheMonth=M_MonthJ

EndIf

M_YM=M_Year&"-"&M_TheMonth%>

<optionvalue="<%=M_YM%>"><%=M_YM%></option>

<%

Next

Next%>

</select>

檢索並刪除數據庫裡的重複記錄

conn.execute("deletefromtablewhereidnotin(selectdistinctfromtable)")