Calculating total of 7th column of my table-->NaN

[KUTTAN]

i want to total of all 7th columns(in all rows) of my table

my tables id is ctl00_ContentPlaceHolder1_Quote1_RadGdProductList_ ctl01

The first row of the table is headings

the following code works fine in IE7
But I am getting 'NaN' when i use Mozilla

i found that
[i]var rowTotal=Number(table.rows.cells[7].firstChild.value);

is causing problem
what should i use to do this that do work in Mozilla and fire fox atlest

I don't know much javascript

my code is bellow
.................................................. ..

function doSubTotal(c){
var subTotal=0;
table=document.getElementById('ctl00_ContentPlaceHolder1_Quote1_RadGdProductList_ctl01');
 
for(var i=1;i<table.rows.length;i++){
 
var rowTotal=Number(table.rows[i].cells[7].firstChild.value);
subTotal=eval(subTotal)+eval(rowTotal);
 
}
 
document.getElementById('ctl00_ContentPlaceHolder1_Quote1_TxtBxSubTotal').value=subTotal;
 
}

.................................................. ............................

[dmjpro]

i want to total of all 7th columns(in all rows) of my table

my tables id is ctl00_ContentPlaceHolder1_Quote1_RadGdProductList_ ctl01

The first row of the table is headings

the following code works fine in IE7
But I am getting 'NaN' when i use Mozilla

i found that
[i]var rowTotal=Number(table.rows.cells[7].firstChild.value);

is causing problem
what should i use to do this that do work in Mozilla and fire fox atlest

I don't know much javascript

my code is bellow
.................................................. ..
function doSubTotal(c){
var subTotal=0;
table=document.getElementById('ctl00_ContentPlaceH older1_Quote1_RadGdProductList_ctl01');

for(var i=1;i<table.rows.length;i++){

var rowTotal=Number(table.rows[i].cells[7].firstChild.value);
subTotal=eval(subTotal)+eval(rowTotal);

}

document.getElementById('ctl00_ContentPlaceHolder1 _Quote1_TxtBxSubTotal').value=subTotal;

}
.................................................. ............................

var rowTotal=Number(table.rows[i].cells[7].firstChild.value);
 

What is "Number" here?
And need not to use "eval" if you convert it into number already.
You can also try this .........

for(var i=1;i<table.rows.length;i++){
var rowTotal=parseInt(table.rows[i].cells[7].firstChild.value);
subTotal=subTotal+rowTotal;
}
 

Debasis Jana

[KUTTAN]

i have done
alert("..."+table.rows[i].cells[7].firstChild.value);

it is the correct number for IE
but
this is undefined for Mozilla

I have also tried parseFloat ,parseInt
nothing good happned
;(

[dmjpro]

i have done
alert("..."+table.rows[i].cells[7].firstChild.value);

it is the correct number for IE
but
this is undefined for Mozilla

I have also tried parseFloat ,parseInt
nothing good happned
;(

So you are using Mozilla.

Use ..............

alert("..."+table.rows[i].childNodes[7].firstChild.value);
 

Debasis Jana

[KUTTAN]

[HTML]<table style="width: 100%; border-collapse: collapse; empty-cells: show;" border="0" cellspacing="0">
<colgroup>
<col>
<col>
<col>
<col>
<col>
<col>
<col>
<col>
<col>
<col>
<col>
</colgroup>
<thead>
<tr>
<th > Code</th><th >Brand</th><th>Product Name</th><th >Remarks</th><th >Unit</th><th class="GridHeader_Default">Qty</th><th class="GridHeader_Default">Unit Price</th><th class="GridHeader_Default">Total</th><th class="GridHeader_Default">Cost</th><th >Stock Position</th><th >Source</th>
</tr>
</thead><tbody>
<tr >
<td>)A1</td><td>Techno Flex</td><td>
<input name="ctl00TxtBxProductName" value="100x6x16" id="ctl00TxtBxProductName" class="RadTextBox3" type="text">
</td><td>
<input name="ctl00TxtBxRemarks" id="ctl00TxtBxRemarks" class="RadTextBox3" type="text">
</td><td>
<select name="ctl00DdlUnit" id="ctl00DdlUnit">
<option selected="selected" value="0"> </option>
<option value="1">Litter</option>

</select>
</td><td>
<input name="ctl00TxtBxQuantity" value="1" id='ctl00TxtBxQuantity' type="text">
</td><td>
<input name="ctl00TxtBxPrice" value="0.00" id="ctl00TxtBxPrice" type="text">
</td><td>
<input name="ctl00TxtBxRowTotal" value="0.00" id="ctl00TxtBxRowTotal" type="text" >&nbsp;
</td><td>
<input name="ctl00TxtBxCost" value="0" id="ctl00TxtBxCost" type="text">&nbsp;
</td><td>
<input name="ctl00TxtBxSource" id="ctl00TxtBxSource" type="text">
</td>
</tr>
</tbody>

</table>[/HTML]

this is my table structure
my table structure is the problem ,there is a tbody

[dmjpro]

Did you use my code?

Debasis Jana.

[KUTTAN]

Did you use my code?

Debasis Jana.

alert("..."+table.rows[i].childNodes[7].firstChild.value);
this is undefined in Mozilla
but ok in IE
my table has tbody thead etc is it a problem?

[dmjpro]

alert("..."+table.rows[i].childNodes[7].firstChild.value);
this is undefined in Mozilla
but ok in IE
my table has tbody thead etc is it a problem?

I think so .. though I am not sure about that.
So have the reference of "TBODY" then try with ....

tbody.chidlNodes[i].childNodes[7].firstChild.value
 

Debasis Jana

[gits]

heya kuttan,

please use code tags when posting source-code ... for example:

[CODE=javascript] your code here [/code]

kind regards