asked on

Using InnnerHTML problem

Guys, im stumped on this.
Im trying to use InnertHTML but im sure there is a problem:

Line 53:
Unknown runtime error.

Any help greatly appreciated.

<html>
<!-------------------------------------------------------------------------
  Get the Service Pack of a list of systems from servfers.txt
---------------------------------------------------------------------------->
 
<head>
<title>Service Pack Information</title>
<HTA:APPLICATION ID="oHTA"
    APPLICATIONNAME="Service Pack Information"
    SINGLEINSTANCE="yes"
    NAVIGABLE="yes"
   >
 
<style type="text/css">
 
html {
font-family:arial;
font-size:smaller;
 
}
 
table {
border-collapse:collapse;
border:solid 1px black;
font-family:arial;
font-size:0.8em;
}
 
tr, td {
border:solid 1px black;
}
 
</style>
 
 
</head>
 
<body>
 
<p><h2 align=center><font color=red>Service Pack Information</font></h2>
<div align=right>S Harding  04/05/2009</div><hr size=1>
This hta application uses VBScript and WMI to enumerate the service pack for systems in a text file.<p>
 
<script language="VBScript">
 
Sub GetServicePack
 
Set objFSO = CreateObject("Scripting.FileSystemObject")
Const intForReading = 1
strComputersFile = "servers.txt"
Set objComputers = objFSO.OpenTextFile(strComputersFile, intForReading, False)
 
DataArea.InnerHTML = "<center><table width='40%' border=1 bgcolor='white'><tr><td style='background:c0c0c0'>" & "<b>System</b>" & "</td><td style='background:c0c0c0'>" & 
 
"<b>Service Pack</b>" & "</td></tr>"
 
While Not objComputers.AtEndOfStream
	strComputer =   objComputers.ReadLine
 
        'If you can connect to the machine, then get the Service pack:
        If Ping(strComputer) = True Then
 
        On Error Resume Next
                Set objWMIService = GetObject("winmgmts:" _
                & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
 
                If Err.Number = 0 Then On Error GoTo 0
 
                'Get Service Pack:
                '-----------------------------------------------------
                Set colSpack = objWMIService.ExecQuery _
                ("Select * from Win32_OperatingSystem")
 
                For Each objSpack in colSpack
                        strSpack = objSpack.ServicePackMajorVersion
                Next
 
 		DataArea.InnerHTML =  "<tr><td>" & strComputer & "</td><td>" & strSpack & "</td></tr>"
	Else
 
		DataArea.InnerHTML =  "<tr><td>" & strComputer & "</td><td style='background:black;'>" & "<font color='red'>Unreachable</font>" & "</td></tr>"
 
        End If
 
  
Wend
 
objComputers.Close
DataArea.InnerHTML =  "</table></center>"
 
End Sub
 
Function Ping(strComputer)
 Dim objShell, boolCode
 Set objShell = CreateObject("WScript.Shell")
 boolCode = objShell.Run("Ping -n 1 -w 300 " & strComputer, 0, True)
 If boolCode = 0 Then
  Ping = True
 Else
  Ping = False
 End If
End Function
 
 
</script>
<span id=DataArea>This is a span area named DataArea</span>
<input id=getsp  class="button" type="button" value="Get Service Pack" name="getsp_button"  onClick="GetServicePack">
</body>
</html>

Open in new window

SOLUTION

Peter Kwan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Simon336697

ASKER

Hi pkwan, thanks so much for your help.
pk, im still getting a runtime error on line 53.
It looks like the DataArea.InnerHTML might be the problem? Just cant figure it out <:(

ASKER CERTIFIED SOLUTION

TakedaT

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Simon336697

ASKER

TakedaT THAT IS BRILLIANT BRILLIANT that works!
Thank you so much mate.
pkwan youre a champion too.
I am in awe of your guy's knowledege and cannot thank you both enough :>)

Simon336697

ASKER

TakedaT i hope you dont mind me asking 1 final question about this.
What you have done is excellent.
Is there a way to slightly modify your code so that:

1) Instead of hardcoding the text file

strComputersFile = "servers.txt" (line 46)

2) You can create a browse button, and point to a text file of your choice?

So, instead of hardcoding

strComputersFile = "servers.txt"

You would have something like:

Please select a file to process ___________ <Browse>

Then the script would process that chosen file instead?

You are fantastic guys.

TakedaT

Here you go. Now, this will ONLY work in windows XP. You will get errors on other operating systems if you try to run it. Even on this pc im on now wont run it (vista).

<!-------------------------------------------------------------------------
Get the Service Pack of a list of systems from servfers.txt
---------------------------------------------------------------------------->
 
<head>
<title>Service Pack Information</title>
<HTA:APPLICATION ID="oHTA"
	APPLICATIONNAME="Service Pack Information"
	SINGLEINSTANCE="yes"
	NAVIGABLE="yes"
>
 
</head>
<style type="text/css">
 
html {
font-family:arial;
font-size:smaller;
 
}
 
table {
border-collapse:collapse;
border:solid 1px black;
font-family:arial;
font-size:0.8em;
}
 
tr, td {
border:solid 1px black;
}
 
</style>
 
<script language="VBScript">
 
Sub GetServicePack
	currentDir = right(location.pathname,instrrev(location.pathname,"\"))
	Set objDialog = CreateObject("UserAccounts.CommonDialog")
	objDialog.Filter = "Text Files|*.txt|All Files|*.*"
	objDialog.FilterIndex = 1
	objDialog.InitialDir = currentDir
	intResult = objDialog.ShowOpen
	If intResult = 0 Then
		MsgBox "Failed to open a file"
		window.close
	End If
	strComputersFile = objDialog.FIlename
	Set objFSO = CreateObject("Scripting.FileSystemObject")
	Const intForReading = 1
 
	Set objComputers = objFSO.OpenTextFile(strComputersFile, intForReading, False)
	strHTML = "<table width='40%' border=1 bgcolor='white'><th style='background:c0c0c0'>" & "<b>System</b>" & "</th><th style='background:c0c0c0'>" & _
	"<b>Service Pack</b>"
	DataArea.InnerHTML = strHTML
	
	While Not objComputers.AtEndOfStream
		strComputer =   objComputers.ReadLine
		
		'If you can connect to the machine, then get the Service pack:
		If Ping(strComputer) = True Then
			
			'On Error Resume Next
			Set objWMIService = GetObject("winmgmts:" _
			& "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
			
			'If Err.Number = 0 Then On Error GoTo 0
			
			'Get Service Pack:
			'-----------------------------------------------------
			Set colSpack = objWMIService.ExecQuery _
			("Select * from Win32_OperatingSystem")
			
			For Each objSpack in colSpack
				strSpack = objSpack.ServicePackMajorVersion
			Next
			
			strHTML =  strHTML&"<tr><td><center>" & strComputer & "</td><td><center>" & strSpack
		Else
			
			strHTML =  strHTML&"<tr><td><center>" & strComputer & "</td><td style='background:black;'><center>" & "<font color='red'>Unreachable</font>"
			
		End If
	Wend
	
	objComputers.Close
	DataArea.InnerHTML =  strHTML&"</table>"
 
End Sub
 
Function Ping(strComputer)
Dim objShell, boolCode
Set objShell = CreateObject("WScript.Shell")
boolCode = objShell.Run("Ping -n 1 -w 300 " & strComputer, 0, True)
If boolCode = 0 Then
Ping = True
Else
Ping = False
End If
End Function
 
 
</script>
<body>
 
<p><h2 align=center><font color=red>Service Pack Information</font></h2>
<div align=right>S Harding  04/05/2009</div><hr size=1>
This hta application uses VBScript and WMI to enumerate the service pack for systems in a text file.<p>
<span id=DataArea>This is a span area named DataArea</span><br>
<input id=getsp  class="button" type="button" value="Get Service Pack" name="getsp_button"  onClick="GetServicePack">
</body>

Open in new window

Simon336697

ASKER

Hi TakedaT, youre a genius.

Those new lines you added.....if you wanted to create a new button to click so that this new button would prompt you for a text file, could you do that?
So, you would have:

<Click to point to a filename>
<Click to Get Service Pack>