Would like to build a list of rows from table, and then select one row to update

As pointed out by ACP, contenteditable is very useful for editing the content of an HTML element.

It is neat to then use AJAX plus ColdFusion to delete/update records on your database.

For example, to delete a database record when you click on the corresponding row of the HTML table:

• Have a ColdFusion template that will do the database manipulation
• onClick() a table row, make an AJAX call (see sample below) to the ColdFusion template
• ColdFusion will then delete or update the database record (the row id comes in handy in your WHERE clause)

<script>

    $(".yourTableClass")

    .on('click', 'tbody tr', function(){

        // Assuming your first cell holds the database table PRIMARY KEY

        // .eq(0) finds the first cell

        var id = $(this).closest('tr').children().eq(0).text();

       // Then delete that record on your database via AJAX, using the id you have picked up

        $.ajax({

            type: "...",

            url: "...",

            dataType: "...",

            data: {

                tablePrimaryKey: id,

                ... : ... ,

                ... : ...

            },

            success: function(result, textStatus, jqXHR) {

                ... ;

                ... ;

            }

        })   // End of ajax call

    })

</script>

There is a cool new attribute in HTML 5:

<td contenteditable="true"></td>