isNull Method

Returns a Boolean value indicating if an output record field is NULL.

Script Syntax

value = objRecord.isNull( index );

value = objRecord.isNull( fieldName );

Parameters

index

An integer containing the 0-based index of the field in the query output records. The index must be less than the number of fields returned by the getColumnCount method of the LogRecordSet object.

fieldName

A string containing the name of the field in the query output records.

Return Value

Examples

JScript example:

var oLogQuery = new ActiveXObject("MSUtil.LogQuery");

// Create query text
var strQuery = "SELECT TimeGenerated, SourceName, EventID, Message, Data FROM System";

// Execute query and receive a LogRecordSet
var oRecordSet = oLogQuery.Execute( strQuery );

// Visit all records
while( !oRecordSet.atEnd() )
{
        // Get a record
        var oRecord = oRecordSet.getRecord();

        // Display record information
        WScript.Echo( "TimeGenerated: " + oRecord.getValue("TimeGenerated") );
        WScript.Echo( "SourceName   : " + oRecord.getValue(1) ); 
        WScript.Echo( "EventID      : " + oRecord.getValue(2) ); 
        if( !oRecord.isNull(3) )
        {
            WScript.Echo( "Message      : " + oRecord.getValue(3) ); 
        }
        else
        {
            WScript.Echo( "Message      : <null>" ); 
        }

        if( !oRecord.isNull("Data") )
        {
            WScript.Echo( "Data         : " + oRecord.getValue(4) ); 
        }
        else
        {
            WScript.Echo( "Data         : <null>" ); 
        }

        // Advance LogRecordSet to next record
        oRecordSet.moveNext();
}

// Close LogRecordSet
oRecordSet.close();

VBScript example:

Dim oLogQuery
Dim oRecordSet
Dim strQuery
Dim f
Dim val

Set oLogQuery = CreateObject("MSUtil.LogQuery")

' Create query text
strQuery = "SELECT TimeGenerated, SourceName, EventID, Message, Data FROM System"

' Execute query and receive a LogRecordSet
Set oRecordSet = oLogQuery.Execute( strQuery )

' Visit all records
DO WHILE NOT oRecordSet.atEnd

	' Get a record
	Set oRecord = oRecordSet.getRecord

        ' Display record information
        WScript.Echo "TimeGenerated: " & oRecord.getValue("TimeGenerated")
        WScript.Echo "SourceName   : " & oRecord.getValue(1)
        WScript.Echo "EventID      : " & oRecord.getValue(2)
        If oRecord.isNull(3) = False Then 
            WScript.Echo "Message      : " & oRecord.getValue(3)
        Else
            WScript.Echo "Message      : <null>"
        End If

        If oRecord.isNull("Data") = False Then 
            WScript.Echo "Data         : " & oRecord.getValue(4)
        Else
            WScript.Echo "Data         : <null>"
        End If

	' Advance LogRecordSet to next record
	oRecordSet.moveNext

LOOP

' Close RecordSet
oRecordSet.close

See also:

© 2004 Microsoft Corporation. All rights reserved.