How to retrieve Cell information from dynamic HTML table?

[Rock6431]

I have a table with CheckBoxes in the left hand column and various information in the other columns in that row. The name property of the CheckBox is dynaically generated, so I can not pull the value of this checkbox as I wouldn't know what name it was assigned when it was generated. I am looking to try to pull the information by looping through the table with something similar to coordinates of (row,col) like in Excel.

Any ideas?

 

[shaneh0]

Without parsing the HTML using the FSO and string functions there is no way to do this. And the parsing option would be slow and inefficient.

Why are your checkboxes being named dynamically? I've never seen that done before. If you give them all one name but different values then you don't have this problem.

 

[dilettante]

I'm unfamiliar with the DOM in various Netscape products (are these documented in any detail?) but for IE later than 3.x this is pretty easy.

The collection tableID.rows returns all of the rows in the table. You navigate this like any other collection in DHTML script.

The collection row.cells will give you access to the cells in the row.

When munching on an individual cell you'll need to pull out the unnamed checkboxes in the elements collection to get their values by using the .children collection of each cell. Identify the child element you want by its tagName value (such as INPUT) and type value (such as CHECKBOX). Be sure to UCase these values to test them, some come back uppercase, others lowercase... in IE 6 for example the case returned matches what was used in the HTML source for the tag.

Browse for details:

http://msdn.microsoft.com/library/d...eference/dhtml_reference_entry.asp?frame=true

 

[Rock6431]

Thanks ShaneH0 and Dilettante,

I created and named each item dynamically, since I use the name and id's for different actions on a specific record. When these goto some of my other functions, I use this information to locate other field or function specific records or account information without having to go back to the database.

As for the location of the HTML field specific info, I found a quicker method of getting the data and thought I would share. I added another column to my HTML table and am pulling the values from that cell as opposed to the name field of the checkbox. All I have to do now is figure out how to hide that column from appearing on the screen, which I guess, I'll just change the text color to that of the background.

Although it is Jscript, the following is a subFunction to my VBscript which returns the cell value to a hidden text field on my page. I then use that value in my VBscript.

<SCRIPT LANGUAGE=&quot;JScript&quot;>
function GetCell(myROW, myCOL) {
document.all.HIDDENFIELD.value = document.all.TABLENAME.rows(myROW).cells(myCOL).innerText;
}
</SCRIPT>


Thanks again for the help.

Rock6431