HTML

Using the HTML Table Element as a Recordset

When you query a database, the result you receive is a recordset. The form in which your result can be presented is affected by the capabilities of the language you use. This can present a challenge for certain languages. This article presents one way to meet that challenge if you program for the web.

Author Info:

By: Chrysanthus Forcha

Poor Best

Rating:

/ 7

July 21, 2008

TABLE OF CONTENTS:

The above HTML table has the data mentioned above. The table is the recordset. Its value for the CSS display property should be “none” if we do not want to see the recordset contents. If we want to see the recordset contents it should be “block.” I have allowed the default value of “block” so that you can see the content.

I will spend the rest of the article telling you how to attain the above five minimum requirements of a recordset.

Total Number of Rows of the Recordset

The following statement returns the reference to an HTML element on the web page based on the ID given.

document.getElementById(id)

If the HTML element is a table, then the following statement would give you the number of rows in the table:

document.getElementById('myTable').rows.length

where myTable is the table ID. Note that word “rows” in the above statement does not take the [] brackets.

In our illustration, the code to give the number of rows is as follows:

var numberOfRows = document.getElementById('Recordset1').rows.length

The ID for our table recordset is ‘Recordset1’.

Open the above file in a browser. Click the “Give No. of Rows” button and an alert box will appear showing the number of rows. In the code the button element calls the function,

function giveNoOfRows()

{

var numberOfRows = document.getElementById('Recordset1').rows.length;

alert(numberOfRows);

}

We shall use a similar approach (button and event) to illustrate the other functions.

Next: Editing Data >>