adding column numbers

decren · April 17th, 2007, 07:46 AM

Hello,
I have a table with an add-row setup. The table has several columns but I only need to calculate COLUMN FOUR. The results go to a textbox via a button. My code is.....

function sumup() {
document.getElementById("Table1")
  column = document.getElementsByTagName("colFour");
  document.myForm.tbTotal.value = column;
}
.....
<TABLE NAME="Table1" id="Table1">
<COL WIDTH=10*>
    <COL WIDTH=139*>
    <COL WIDTH=27*>
    <COL WIDTH=29*>
    <COL WIDTH=27* NAME="colFour" id="colFour">
    <COL WIDTH=10*>
.....
<INPUT TYPE=TEXT NAME="tbTotal">
<INPUT TYPE=BUTTON NAME="pbTest" VALUE="TEST" onclick="sumup();"./>
.....But when I click pbTest, the result in tbTotal is.....
[object]
.....What am I doing wrong?

decren

joefawcett · April 17th, 2007, 09:27 AM

getElementsByTagName retrieves elements by tag name, your table will have rows of tr with cells of td. You need something like:

Code:

var oTable = document.getElementById("Table1");
var colRows = oTable.rows;
var dTotal = 0.0;
for (var i = 0; i < colRows.length; i++)
{
  var oRow = colRows[i];
  var oCell = oRow.cells[3];
  dTotal += //get data from cell, you haven't shown how it's held...
}
alert(dTotal);

--

Joe (Microsoft MVP - XML)

decren · May 5th, 2007, 07:48 AM

Thank you joefawcett for the code. I played around with it a little but couldn't get it tweaked just right. But you did give me some ideas which I used to tweak a table I found at:
http://4umi.com/web/javascript
Again, thanx for the input.

decren