[gears-users] parameters

[meerkat]

//var this_main_detail_id = getValue("main_detail_id");
OR
        var this_main_detail_id ="034115441312108";

        var tbl = $('notes');
        while(tbl.rows.length > 0)
        tbl.deleteRow(-1);

        var sql = "SELECT main_detail_id,staff_notes FROM main_detail WHERE
main_detail_id = this_main_detail_id";


OR
        var sql = "SELECT main_detail_id,staff_notes FROM main_detail WHERE
main_detail_id = "+this_main_detail_id;
OR
var rs = db.execute('SELECT main_detail_id FROM main_detail '+
                'where main_detail_id=?',[this_main_detail_id]);

Hello,

I am trying to use parameters with Gears sqlite database. I have tried
the above but I can't get the value selected or bound in the sql. When
I write the parameter by itself I get the correct value.

Any ideas on the correct way to do this?

Thanks,
Tosca