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.

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@systemmanager.forsenergy.ru to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.