14. januar 2000 - 00:22Der er
9 kommentarer og 1 løsning
On error../if Err. Then??
Hvordan fan.... fanger man fejl i et ASP script?????
Jeg har et "action-script" med en helvedes masse funktioner, der udføres afhængigt af en querystring, og jeg ville gerne fange evt. fejl, der kunne opstå.
Men hvordan placerer man If Err. og ON Error så de fanger fejl for hele siden??????
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
Selvom jeg fremprovokerer en fejl ved at skrive forkert i SQL'en, så hopper den videre...??
Mine kode:
If err.number > 0 Then Response.write("<br><hr><h3><b>Error Report</b></h3><hr>") Response.write("<b>Server Side Error(s) Occured</b><br><br>") Response.write("Error Number: " & err.number) Response.write(" (This is a " & err.description & ")") Response.write("<br><br>Help Context=" & err.helpcontext) Response.write("<br>Help Path=" & err.helppath ) Response.write("<br>Native Error=" & err.nativeerror) Response.write("<br>Source=" & err.source) Response.write("<br><br>SQLState=" & err.sqlstate)
Else
If Request.Querystring("mode")="create" Then Response.Redirect "Admin_confirm.asp?mode=create" If Request.Querystring("mode")="edit" Then Response.Redirect "Admin_confirm.asp?mode=edit" If Request.Querystring("mode")="delete" Then Response.Redirect "oversigt.asp"
IMHO Er det meget svært at lave generel fejlbehandling for hele dit script - da fejlaktionen ofte afhænger af hvad der er gået galt, og om det overhovedet er muligt at fortsætte. Fejlbehandlingen skal indgå som en integreret del af scriptet.
Hvis der skal indgåes kompromis kan du gøre det på øverste niveau af kalde hirakiet - hvilket ofte ikke er så svært, hvis man bare tager stille og roligt fra en ende af.
Du kan jo teste on det virker ved at skrive inI =5/0 lige før der testes på error.
<% ' Variables ' ********* Dim mySmartUpload Dim file Dim oConn Dim strSQL Dim oRs Dim intCount intCount=0 ' Object creation ' *************** Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload") ' Upload ' ****** mySmartUpload.Upload ' Connect to the DB ' ***************** Set oConn = Server.CreateObject("ADODB.Connection") curDir = Server.MapPath("\scripts\aspSmartUpload\Sample.mdb") oConn.Open "DBQ="& curDir &";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;" ' Open a recordset ' **************** strSQL = "SELECT FILENAME,FILE FROM TFILES" Set oRs = Server.CreateObject("ADODB.recordset") Set oRs.ActiveConnection = oConn oRs.Source = strSQL oRs.LockType = 3 oRs.Open ' Select each file ' **************** For each file In mySmartUpload.Files ' Only if the file exist ' ********************** If not file.IsMissing Then ' Add the current file in a DB field ' ********************************** oRs.AddNew file.FileToField oRs.Fields("FILE") oRs("FILENAME") = file.FileName oRs.Update intCount = intCount + 1 End If Next ' Display the number of files uploaded ' ************************************ Response.Write(intCount & " file(s) uploaded.<BR>") ' Destruction ' *********** oRs.Close oConn.Close Set oRs = Nothing Set oConn = Nothing %>
<% ' Variables ' ********* Dim mySmartUpload Dim file Dim oConn Dim oRs Dim intCount intCount=0
' Object creation ' *************** Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload")
' Upload ' ****** mySmartUpload.Upload
' Connect to the DB ' ***************** Set oConn = Server.CreateObject("ADODB.Connection") curDir = Server.MapPath("\scripts\aspSmartUpload\Sample.mdb") oConn.Open "DBQ="& curDir &";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;"
' Open a recordset ' **************** strSQL = "SELECT FILENAME,FILE FROM TFILES"
Set oRs = Server.CreateObject("ADODB.recordset") Set oRs.ActiveConnection = oConn oRs.Source = strSQL oRs.LockType = 3 oRs.Open
' Select each file ' **************** For each file In mySmartUpload.Files ' Only if the file exist ' ********************** If not file.IsMissing Then
' Add the current file in a DB field ' ********************************** oRs.AddNew file.FileToField oRs.Fields("FILE") oRs("FILENAME") = file.FileName oRs.Update intCount = intCount + 1 End If Next
' Display the number of files uploaded ' ************************************ Response.Write(intCount & " file(s) uploaded.<BR>")
' Destruction ' *********** oRs.Close oConn.Close Set oRs = Nothing Set oConn = Nothing %>
Du skal sætte din 'ON ERROR' i starten i scriptet.
Jeg har sakset lidt info fra Microsoft VBScripting-help:
Description: Enables error-handling.
Syntax: On Error Resume Next
Remarks: If you don't use an On Error Resume Next statement, any run-time error that occurs is fatal; that is, an error message is displayed and execution stops. On Error Resume Next causes execution to continue with the statement immediately following the statement that caused the run-time error, or with the statement immediately following the most recent call out of the procedure containing the On Error Resume Next statement. This allows execution to continue despite a run-time error. You can then build the error-handling routine inline within the procedure. An On Error Resume Next statement becomes inactive when another procedure is called, so you should execute an On Error Resume Next statement in each called routine if you want inline error handling within that routine.
The following example illustrates use of the On Error Resume Next statement:
On Error Resume Next Err.Raise 6 'Raise an overflow error. MsgBox ("Error # " & CStr(Err.Number) & " " & Err.Description) Err.Clear ' Clear the error.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.