Jquery.tmpl with WebSql Result set

Question

I am using JQM and building a large lists of contacts from a webSQL database. Currently the process is painfully slow so I am trying to use a template to see how this affects performance.

I cannot figure out how to use a Jquery template with a WebSQL ResulSet.

This is the code so far:

function (tx, result)
{
    var markup = '<li><a href="#contact">${result.Name}</a></li>';
    $.template("contactTemplate", markup);
    $.tmpl("contactTemplate", /* What goes here? */).appendTo($list);
}

score 0 · Accepted Answer · answered May 09 '12 at 11:27

Ok, Jquery template expects an array. Therefore the following works:

var contacts = [];

for (i = 0; i < result.rows.length; i++)
{
    contacts.push(result.rows.item(i));
}

var markup = '<li><a href="#contact">${Name}</a></li>';
$.template("contactTemplate", markup);

$.tmpl("contactTemplate", contacts).appendTo($list);

This approach has very little impact on performance. Building the list is equally slow.

Jquery.tmpl with WebSql Result set

1 Answers1