I've made a simple page which creates a database, table etc. I can delete and add records from the the page and the rows are displayed inside text boxes.
I just want to be able to edit the contents of the rows via the text boxes and click the save button to update the row, but no matter what I do I can't get it to work.
tx.executeSql('UPDATE groupOne SET name = 4, amount = 5 WHERE id=?', [id], renderRecords)works to set the contents of each row to 4 and 5, but how do i substitute the 4 and 5 for the text box values, it seems so simple but its beyond me!!
Hopefully someone can help, I'm properly stuck now. The full code is at Machine totals (Pastebin)