Recommended: Revealing 2 ways to solve the script timeout when ASP runs When running ASP, I encountered a script timeout problem, and the prompt message was: "ActiveServerPages error 'ASP0113 script timeout'". Solution: Modify two places: First: Open IIS-local computer, click on the website, right-click ---Properties-Home Directory-Configuration-Options--ASP script timeout time, it can be changed to 60-90 Second or higher; second: % session.
When debugging the student management system, if you want to modify the student status information, if the data in the database has been completely deleted at this time, there will be an error in BoF or Eof that is true, or the current record has been deleted. What we need to do now is Before using the moveNext and other methods of the Recordset object, use the RecordsetCount property to determine whether the data in the database is empty:dimobjRsasNewRecordset
dimobjCnasNewconnection
dimstrSqlasstring
objCn.ConnectionString=fileDsn=student.dsn;User_Id=sa;PassWord=123
objcn.open
strSql=SELECT*FROMStudent_info
objRs.OpenstrSql,objCn,adOpenKeyset,adLockOptimistic
'In this judgment, if it is empty, just inform the user and exit the module operation.
ifobjRS.RecordsetCount=0then
The msgbox student status information does not exist, please add it and then operate it!
objRs.Close
SetobjRs=Nothing
Don't forget this step, otherwise you will have to report an error, because the future operations are still performed
endif
This can solve this problem and continue to operate in the future. If we write the function linking the database in advance and return the records to the Recordset, the steps can be omitted!
Share: How to set the cookies expiration time asp Response.Cookies(user_name).Expires=Date+1'Specify the cookie saving time to retain COOKIES for one hour Response.Cookies(MyCookie).Expires=(now()+1/24) Response.Cookies(MyCookie).Expires=DateAdd( h,1,Now()) Response.Cookies(CookieName).Expires=DateAdd