Comparing webtable data with weblist and webelements in other webpage

[arnav]

Hi Guys,

I need script for the following scenarios.

1. Comapring names in a webtable in a webpage with the names in the weblist in another page.

2. Comparing dates in a webtable in a webpage with the dates the dates in other webpage displaying as a webelement

Please help me on this. I need that urgently.

[Parke]

Arnav:

The following code has not been tested. I would use an arrayList as elements can be added or removed without having to reDim a normal vbscript array.

Code:

Set arrL_1 = dotnetfactory.CreateInstance("System.Collections.ArrayList")
Set arrL_2 = dotnetfactory.CreateInstance("System.Collections.ArrayList")

numRows = browser(b).Page(p).WebTable(nme).RowCount
print "num rows = " & numRows
''assume your column names/header is row one
'' add the names to the first arraylist
for i = 2 to numRows
    arrl_1.add browser(b).page(p).webTable(nme).getCellDate(i,columnNames)
next


'' for a list
'' do not remember if a list count starts with zero or one
list_count = Browser(b).page(p).WebList(listName).getROProperty("items count")
for j = 0 to list_count - 1
    browser(b).page(p).webTable(nme).getCellDate(i,columnNames)
Next

'' you can sort the arrayLists
arrL_1.sort
arrL_2.sort
[\code]


Another method would be to create a strtable and a strList.

[code]
strTable = ""
for i = 2 to numRows
    strTable = strTable & browser(b).page(p).webTable(nme).getCellDate(i,columnNames)
next

strList = ""
for j = 0 to list_count - 1
    strList = strList & "::" & browser(b).page(p).webTable(nme).getCellDate(i,columnNames)
next

'' do a split on the two strings, strList_arr = split(strList,"::") and compare these arrays.

There are lots of examples of how to compare two arrays.
hth,

Parke