Recommended: How to write SQL statements that query all records without a certain field with no value? Sometimes we need to query all records that have no value in a certain field. Should we use rs(xx)= or IsNull(rs(xx))? To draw a conclusion, we have to start from the beginning: Under what circumstances will there be no value in the field? Because this and
| The following is the quoted content: <% Dim IP, IPString, VisitIP 'The IP address to be prohibited IPString=|195.225.177.34|195.225.177.137|72.232.250.10| 'Get IP address IP = Request.ServerVariables(HTTP_X_FORWARDED_FOR) If IP = Then IP = Request.ServerVariables(REMOTE_ADDR) End If VisitIP=|&IP&| If instr(1,IPString, VisitIP)>0 Then response.write Your IP is prohibited from posting messages. If necessary, please contact the webmaster. If you are sending trash, I advise you to stop! response.end End If 'response.Write (Your IP:&IP& can access this site) %> |
Note: Remember to embed this code into the head of the final execution page (not necessarily for the comment post page). Most of the garbage is directly POST data to the execution page. It is recommended to modify the file name of the final execution page and the action in the form tag of the message posting page linked to it from time to time.
Share: ASP instance: Access is a website statistics system for backend database An example of statistical production that can number visitors, record number of visits, IP, and time. I take the ACCESS library as an example. In fact, using the SQL SERVER library, you can just change the statements of the link library. The library structure is as follows: CONT.ASP was originally CONT.