Recommended: Common syntax of 11 databases in ASP programming This article mainly introduces the common syntax for ASP connections to 11 databases. For details, please refer to the following: 1. DSN-less connection method of Access database: The following is the referenced content: set adocon=Server.Createobject(adodb.connection) adoconn.OpenDriver={Microsoft Access Driver(*.mdb)}; DBQ= _ Server.MapPath
Some ASP codes worth collecting some ASP codes worth collecting
1. oncontextmenu=window.event.returnvalue=false will completely block the right mouse button
<table border oncontextmenu=return(false)><td>no</table> can be used for Table
2. <body onselectstart=return false> Unselect and prevent copying
3. onpaste=return false not allowed to paste
4. oncopy=return false; oncut=return false; prevent copying
5. <link rel=Shortcut Icon href=favicon.ico> Change to your own icon in front of the IE address bar
6. <link rel=Bookmark href=favicon.ico> can display your icon in your favorites
7. <input style=ime-mode:disabled> Close the input method
8. Always carry a frame
<script language=javascript><!--
if (window == top)top.location.href = frames.htm; //frames.htm is the frame web page
// --></script>
9. Prevent frames from being
<SCRIPT LANGUAGE=javascript><!--
if (top.location != self.location)top.location=self.location;
// --></SCRIPT>
10. <noscript><iframe src=*.html></iframe></noscript> The web page will not be saved as
11. <input type=button value=View web page source code
onclick=window.location = 'view-source:' 'http://www.csdn.net/';>
12. How to check whether the client uses the agent through Asp
<% if Request.ServerVariables(HTTP_X_FORWARDED_FOR)<> then
response.write <font color=#FF0000>You have passed the proxy server, & _
The real IP is &Request.ServerVariables(HTTP_X_FORWARDED_FOR)
end if
%>
13. Get the absolute position of the control
//javascript
<script language=javascript> function getIE(e){
var t=e.offsetTop;
var l=e.offsetLeft;
while(e=e.offsetParent){
t =e.offsetTop;
l =e.offsetLeft;
} alert(top= t /nleft= l);
} </script>
//VBScript
<script language=VBScript><!--
function getIE()
dim t,l,a,b
set a=document.all.img1
t=document.all.img1.offsetTop
l=document.all.img1.offsetLeft
while a.tagName<>BODY
set a = a.offsetParent
t=t a.offsetTop
l=l a.offsetLeft
wend
msgbox top=&t&chr(13)&left=&l,64, get the position of the control
end function
--></script>
14. The cursor is stopped at the end of the text box
<script language=javascript> function cc()
{ var e = event.srcElement;
var r =e.createTextRange();
r.moveStart('character',e.value.length);
r.collapse(true);
r.select();
} </script> <input type=text name=text1 value=123 onfocus=cc()>
15. Determine the source of the previous page
asp:
request.servervariables(HTTP_REFERER)
javascript:
document.referrer
16. Minimize, maximize, close windows
<object id=hh1 classid=clsid:ADB880A6-D8FF-11CF-9377-00AA003B7A11>
<param name=Command value=Minimize></object> <object id=hh2 classid=clsid:ADB880A6-D8FF-11CF-9377-00AA003B7A11>
<param name=Command value=Maximize></object> <OBJECT id=hh3 classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11> <PARAM NAME=Command value=Close></OBJECT>
<input type=button value=minimize onclick=hh1.Click()> <input type=button value=maximize onclick=hh2.Click()> <input type=button value=close onclick=hh3.Click()> This example applies to IE
17.
<%
'Define some constants for database connection
Const adOpenForwardOnly = 0 'The cursor only browses the records forward, does not support paging, Recordset, BookMark
Const adOpenKeyset = 1 'Keyset cursor, the modifications made by other users to the record will be reflected in the record set, but other users add or delete records will not be reflected in the record set. Supports pagination, Recordset, BookMark
Const adOpenDynamic = 2 'The dynamic cursor has the strongest function, but also consumes the most resources. The modifications, additions or deletions of records by users to records will be reflected in the record set. Support full-featured browsing (ACCESS does not support).
Const adOpenStatic = 3 'Static cursor is just a snapshot of the data. The modifications made by the user to the record, addition or deletion of the records will not be reflected in the record set. Supports forward or backward movement
Const adLockReadOnly = 1 'Lock type, default, read-only, no modification can be made
Const adLockPessimistic = 2 'Lock records immediately when editing, the safest way
Const adLockOptimistic = 3 'The record set is locked only when the Update method is called, and other previous operations can still change, insert and delete the current record, etc.
Const adLockBatchOptimistic = 4 'The record will not be locked when editing, while changes, insertions and deletion are done in batch mode
Const adCmdText = &H0001
Const adCmdTable = &H0002
%>
18. The web page will not be cached
HTM web page
<META HTTP-EQUIV=pragma CONTENT=no-cache> <META HTTP-EQUIV=Cache-Control CONTENT=no-cache, must-revalidate> <META HTTP-EQUIV=expires CONTENT=Wed, 26 Feb 1997 08:21:57 GMT> or <META HTTP-EQUIV=expires CONTENT=0> ASP web page
Response.Expires = -1
Response.ExpiresAbsolute = Now() - 1
Response.cachecontrol = no-cache
PHP Web Page
header(Expires: Mon, 26 Jul 1997 05:00:00 GMT);
header(Cache-Control: no-cache, must-revalidate);
header(Pragma: no-cache);
19. Check whether a string is composed of numbers
<script language=javascript><!--
function checkNum(str){return str.match(//D/)==null}
alert(checkNum(1232142141))
alert(checkNum(123214214a1))
// --></script>
20. Get the size of a window
document.body.clientWidth,document.body.clientHeight
21. How to determine whether it is a character
if (/[^/x00-/xff]/g.test(s)) alert(contains Chinese characters);
else alert (all characters);
22. How many lines of TEXTAREA adaptive text
<textarea rows=1 name=s1 cols=27 onpropertychange=this.style.posHeight=this.scrollHeight> </textarea>
23. Date minus days equal to the second date
<script language=javascript> function cc(dd,dadd)
{ //Error processing can be added
var a = new Date(dd)
a = a.valueOf()
a = a - dadd * 24 * 60 * 60 * 1000
a = new Date(a)
alert(a.getFullYear() year (a.getMonth() 1) month a.getDate() day)
} cc(12/23/2002,2)
</script>
24. Which Radio was selected
<HTML><script language=vbscript> function checkme()
for each ob in radio1
if ob.checked then window.alert ob.value
next
end function
</script><BODY> <INPUT name=radio1 type=radio value=style checked>Style
<INPUT name=radio1 type=radio value=barcode>Barcode
<INPUT type=button value=check onclick=checkme()> </BODY></HTML>
25. Obtain the request.servervariables() collection of url on this page
Response.Write <TABLE border=1><!-- Table Header --><TR><TD><B>Variables</B></TD><TD><B>value</B></TD></TR>
for each ob in Request.ServerVariables
Response.Write <TR><TD>&ob&</TD><TD>&Request.ServerVariables(ob)&</TD></TR>
next
Response.Write </TABLE>
26.
Native ip<%=request.servervariables(remote_addr)%> Server name<%=Request.ServerVariables(SERVER_NAME)%> Server IP<%=Request.ServerVariables(LOCAL_ADDR)%> Server port<%=Request.ServerVariables(SERVER_PORT)%> Server time<%=now%> IIS version<%=Request.ServerVariablesSERVER_SOFTWARE)%> Script timeout time<%=Server.ScriptTimeout%> The path of this file is <%=server.mappath(Request.ServerVariables(SCRIPT_NAME))%> Number of server CPUs <%=Request.ServerVariables(NUMBER_OF_PROCESSORS)%> Server interpretation engine <%=ScriptEngine & /& ScriptEngineMajorVersion &.&ScriptEngineMinorVersion&.& ScriptEngineBuildVersion %> Server operating system <%=Request.ServerVariables(OS)%>
27.ENTER key allows the cursor to move to the next input box
<input onkeydown=if(event.keyCode==13)event.keyCode=9>
28. Detect the link speed of a certain website:
Add the following code to the <body> area:
<script language=javascript> tim=1
setInterval(tim,100)
b=1
var autourl=new Array()
autourl[1]=www.njcatv.net
autourl[2]=javacool.3322.net
autourl[3]=www.sina.com.cn
autourl[4]=www.nuaa.edu.cn
autourl[5]=www.cctv.com
function butt(){
document.write(<form name=autof>)
for(var i=1;i<autourl.length;i )
document.write(<input type=text name=txt i size=10 value=In test...> =》<input type=text name=url i size=40> =》<input type=button value=GO onclick=window.open(this.form.url i.value)><br/>)
document.write(<input type=submit value=refresh></form>)
} butt()
function auto(url){
document.forms[0][url b].value=url
if(tim>200)
{document.forms[0][txt b].value=link timeout}
else
{document.forms[0][txt b].value=time tim/10 seconds}
b
} function run(){for(var i=1;i<autourl.length;i )document.write(<img src=http:// autourl / Math.random() width=1 height=1 oneerror=auto('http://;; autourl ')>)}
run()</script>
29. Various styles of cursors
auto: standard cursor
default: standard arrow
hand: hand cursor
wait : Wait for the cursor
text: I-shaped cursor
vertical-text: horizontal I-shaped cursor
no-drop: The cursor cannot be dragged
not-allowed: Invalid cursor
help :?Help cursor
all-scroll: triangle direction mark
move: mobile tag
crosshair: crosshair
e-resize
n-resize
nw-resize
w-resize
s-resize
se-resize
sw-resize
Share: How to prevent ASP from logging in at the same time There are two ways to implement this function: 1. application: If you are doing a large community, you may have to generate an application for each login id. Although the program design will be simpler, the login user is too many and it consumes server resources. It is never recommended here, because the application object is easy to generate when the user login.