Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Computing for a dynamic value in a HTML Table
- Thread starter totogella
- Start date
[tt]
Can you show an exaple of what you're looking for?
[ul][li]What do all these errors in ASP really mean? .... [/li] [li]What are the many ways to send emails with ASP? .... [/li][li]Where can I learn ASP? .... [/li][/ul]
Can you show an exaple of what you're looking for?
[ul][li]What do all these errors in ASP really mean? .... [/li] [li]What are the many ways to send emails with ASP? .... [/li][li]Where can I learn ASP? .... [/li][/ul]
- Thread starter
- #3
Sure!
Col1 Col2 Col3 Col4
Value1 1 2 3 4
Value2 4 5 6 7
Value3 2 4 6 8
----------------------------------
Total 7 11 15 19
Where the values in the table dynamically change so the total fields should also update as the values change.
Thanks!
Col1 Col2 Col3 Col4
Value1 1 2 3 4
Value2 4 5 6 7
Value3 2 4 6 8
----------------------------------
Total 7 11 15 19
Where the values in the table dynamically change so the total fields should also update as the values change.
Thanks!
I believe there is a way to do this.
I am in the middle of a script right now and it would ask a little investement to create such a script (well to learn how to do it anyways).
I can direct you to mozilla ref. that deals with tables.
You can also see in google for scripts that sort tables. It might give you a good start. Gary Haran
I am in the middle of a script right now and it would ask a little investement to create such a script (well to learn how to do it anyways).
I can direct you to mozilla ref. that deals with tables.
You can also see in google for scripts that sort tables. It might give you a good start. Gary Haran
flowcontrol
Programmer
You say, "the values in the table dynamically change". What makes them change? Is the user changing them? Or, are you running some Java or Javascript that is changing them?
Are the values in the table inside text fields or just simply displayed?
What browsers must it work with?
Are the values in the table inside text fields or just simply displayed?
What browsers must it work with?
- Thread starter
- #6
flowcontrol
Programmer
OK. If the other program redraws the entire page, why doesn't it do the calculations? Or, is it just changing the values in the table and NOT redrawing the page?
I think I might have a solution. give me about ten minutes to see if it will work. No guarantee though. Gary Haran
it's getting closer. 5 more minutes and I got it! 
Gary Haran
Gary Haran- Thread starter
- #10
It works in mozilla right now. However I need to patch it for IE to work. Give me a few more minutes.
<html>
<head>
<title>test for tables</title>
</head>
<body>
<table id="myTable">
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
</tr>
<tr>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
</tr>
<tr>
<td>9</td>
<td>10</td>
<td>11</td>
<td>12</td>
</tr>
</table>
<script>
var values = [];
var table = document.getElementById("myTable"
;
var trs = table.getElementsByTagName("tr"
// create a multidimensional array
for(var ii = 0; ii < trs.length; ii++)
{
values[ii] = [];
}
// store all values inside all the multidimensional array
for (var trIndex = 0; trIndex < trs.length; trIndex++)
{
var tds = trs[trIndex].getElementsByTagName("td"
for (var tdIndex = 0; tdIndex < tds.length; tdIndex++)
{
values[trIndex][tdIndex] = parseFloat(tds[tdIndex].innerHTML)
}
}
var sums = []
for (var row = 0; row < values[0].length; row++)
{
sums[row] = 0;
for(var col = 0; col < values.length; col++)
{
sums[row] += values[col][row]
}
}
// create a new row
tr = document.createElement("tr"
for (var ii = 0; ii < sums.length; ii++)
{
td = document.createElement("td"
td.innerHTML = sums[ii]
tr.appendChild(td)
}
table.appendChild(tr)
</script>
</body>
</html> Gary Haran
<html>
<head>
<title>test for tables</title>
</head>
<body>
<table id="myTable">
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
</tr>
<tr>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
</tr>
<tr>
<td>9</td>
<td>10</td>
<td>11</td>
<td>12</td>
</tr>
</table>
<script>
var values = [];
var table = document.getElementById("myTable"
;var trs = table.getElementsByTagName("tr"
;// create a multidimensional array
for(var ii = 0; ii < trs.length; ii++)
{
values[ii] = [];
}
// store all values inside all the multidimensional array
for (var trIndex = 0; trIndex < trs.length; trIndex++)
{
var tds = trs[trIndex].getElementsByTagName("td"
;for (var tdIndex = 0; tdIndex < tds.length; tdIndex++)
{
values[trIndex][tdIndex] = parseFloat(tds[tdIndex].innerHTML)
}
}
var sums = []
for (var row = 0; row < values[0].length; row++)
{
sums[row] = 0;
for(var col = 0; col < values.length; col++)
{
sums[row] += values[col][row]
}
}
// create a new row
tr = document.createElement("tr"
for (var ii = 0; ii < sums.length; ii++)
{
td = document.createElement("td"
td.innerHTML = sums[ii]
tr.appendChild(td)
}
table.appendChild(tr)
</script>
</body>
</html> Gary Haran
either we are faced with yet another bug in IE or I am not capable of patching for IE.
I tried using appendChild inserRow and even insertAdjacentHTML and it doesn't let me do anything to the table.
Here is a patchy and ugly way to make it work in IE :
<html>
<head>
<title>test for tables</title>
</head>
<body>
<table id="myTable">
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
</tr>
<tr>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
</tr>
<tr>
<td>9</td>
<td>10</td>
<td>11</td>
<td>12</td>
</tr>
</table>
<div id="totalContainer"></div>
<script>
var values = [];
var table = document.getElementById("myTable"
var trs = table.getElementsByTagName("tr"
// create a multidimensional array
for(var ii = 0; ii < trs.length; ii++)
{
values[ii] = [];
}
// store all values inside all the multidimensional array
for (var trIndex = 0; trIndex < trs.length; trIndex++)
{
var tds = trs[trIndex].getElementsByTagName("td"
for (var tdIndex = 0; tdIndex < tds.length; tdIndex++)
{
values[trIndex][tdIndex] = parseFloat(tds[tdIndex].innerHTML)
}
}
var sums = []
for (var row = 0; row < values[0].length; row++)
{
sums[row] = 0;
for(var col = 0; col < values.length; col++)
{
sums[row] += values[col][row]
}
}
// create a new row
tr = document.createElement("tr"
for (var ii = 0; ii < sums.length; ii++)
{
td = document.createElement("td"
td.innerHTML = sums[ii]
tr.appendChild(td)
}
if (!document.all) // for mozilla and other working browsers
{
table.appendChild(tr)
}
else // for buggy IE
{
var table = document.createElement("table"
table.appendChild(tr)
document.getElementById("totalContainer".innerHTML = table.innerHTML;
}
</script>
</body>
</html>
I hate IE sometimes. Gary Haran
I tried using appendChild inserRow and even insertAdjacentHTML and it doesn't let me do anything to the table.
Here is a patchy and ugly way to make it work in IE :
<html>
<head>
<title>test for tables</title>
</head>
<body>
<table id="myTable">
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
</tr>
<tr>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
</tr>
<tr>
<td>9</td>
<td>10</td>
<td>11</td>
<td>12</td>
</tr>
</table>
<div id="totalContainer"></div>
<script>
var values = [];
var table = document.getElementById("myTable"
;var trs = table.getElementsByTagName("tr"
;// create a multidimensional array
for(var ii = 0; ii < trs.length; ii++)
{
values[ii] = [];
}
// store all values inside all the multidimensional array
for (var trIndex = 0; trIndex < trs.length; trIndex++)
{
var tds = trs[trIndex].getElementsByTagName("td"
;for (var tdIndex = 0; tdIndex < tds.length; tdIndex++)
{
values[trIndex][tdIndex] = parseFloat(tds[tdIndex].innerHTML)
}
}
var sums = []
for (var row = 0; row < values[0].length; row++)
{
sums[row] = 0;
for(var col = 0; col < values.length; col++)
{
sums[row] += values[col][row]
}
}
// create a new row
tr = document.createElement("tr"
for (var ii = 0; ii < sums.length; ii++)
{
td = document.createElement("td"
td.innerHTML = sums[ii]
tr.appendChild(td)
}
if (!document.all) // for mozilla and other working browsers
{
table.appendChild(tr)
}
else // for buggy IE
{
var table = document.createElement("table"
table.appendChild(tr)
document.getElementById("totalContainer"
.innerHTML = table.innerHTML;}
</script>
</body>
</html>
I hate IE sometimes. Gary Haran
well I hope this prototype does give you insight on how it can be done. Do note that it will not work in anything below 5.0 browsers.
I hope this helps. I gotta go to sleep now. Ciao Gary Haran
I hope this helps. I gotta go to sleep now. Ciao Gary Haran
- Thread starter
- #14
- Status
Similar threads
- Locked
- Question
- Locked
- Question