asp-classic - 函数错误需要对象 800a01a8

Question

我对函数和类比较陌生，所以不太确定这是否是初学者的错误。我得到:

Microsoft VBScript runtime error '800a01a8' 

Object required: 'EngineerNote(...)' 

/backup-check/backup_frontendlist_import_NEW.asp, line 76 

第 76 行是:

Set NoteArray=EngineerNote(company, servername, backupsolution)

我传递的三个变量都是字符串。所有的函数和类都设置在:

Class EngineerNoteClass
public note
public notesubmitdate
End Class

Function EngineerNote(Company, ServerName, Solution)
Set RecordSet = Server.CreateObject("ADODB.Recordset")
RecordSetSQLString = "SELECT note, submitdate FROM tbl_BackupChecks_AuditInformation WHERE Company='" & company & "' AND ServerName='" & servername & "' AND Solution='" & solution & "' ORDER BY submitdate desc;"
RecordSet.Open RecordSetSQLString, DatabaseConnection
If Recordset.EOF Then
'Do Nothing
Else
Dim NoteResults
Set NoteResults = new EngineerNoteClass
noteresults.note = RecordSet("note")
noteresults.notesubmitdate = RecordSet("submitdate")
Set Engineernote = NoteResults
End If
Recordset.Close
End Function

Answer 1

您的数据库查询很可能没有返回任何结果。仅当记录集不在 EOF 时才设置函数的返回值:

If Recordset.EOF Then
  'Do Nothing
Else
  ...
  Set Engineernote = NoteResults
End If

在 Then 分支中将返回值设置为 Nothing(或空的 EngineerNoteClass 对象)应该会使错误消失:

If Recordset.EOF Then
  Set EngineerNote = Nothing
Else
  ...
  Set Engineernote = NoteResults
End If

确保在脚本的其余部分中正确处理返回的值/对象。