JQuery Mobile Help - populate textbox from database

See more:

Mobile

jQuery

database

I am very new to mobile programming. I am trying to retrieve data from my table and display the record's columns in the appropriate textboxes on the form so they can be edited before clicking the Update button.

When the win_edit page is called I want to wipe out all the textboxes using the blank var. Then I want to read the database PWList table using the Select statement...which will return 1 row. The Alert never happens ! Any ideas on what I am doing wrong ?

Thanks !

$("#win_edit").on( "pagebeforeshow", function( event )
{
var blank="";

$("#tbTitle").val(blank);
$("#tbWebAddress").val(blank);
$("#tbUserName").val(blank);
$("#tbEMail").val(blank);
$("#tbPassword").val(blank);
$("#tbAnswer1").val(blank);
$("#tbAnswer2").val(blank);
$("#tbAnswer3").val(blank);
$("#tbNotes").val(blank);

db.transaction (function (transaction)
{
var sql = "SELECT * FROM PWList Where intPWListID=?";
transaction.executeSql (sql, [sessionStorage.SelectedID],
function (transaction, result)
{
alert("here");
if (result.rows.length)
{
for (var i = 0; i < result.rows.length; i++)
{
var row = result.rows.item (i);
$("#tbTitle").val(row.varTitle);
$("#tbWebAddress").val(row.varWebAddress);
$("#tbUserName").val(row.varUserName);
$("#tbEMail").val(row.varEMail);
$("#tbPassword").val(row.varPWord);
$("#tbAnswer1").val(row.varAnswer1);
$("#tbAnswer2").val(row.varAnswer2);
$("#tbAnswer3").val(row.varAnswer3);
$("#tbNotes").val(row.varNotes);

}
}

}, error);
});
$.mobile.changePage ($("#win_edit"));
});