Hello,
I am trying to use parameters in a simple sql query for sqlite. I have
tried:
var $this_main_detail_id ="34115441312108";
var tbl = $('notes');
while(tbl.rows.length > 0)
tbl.deleteRow(-1);
//var sql = "SELECT main_detail_id FROM main_detail WHERE
main_detail_id = 'this_main_detail_id'";
// var sql = "SELECT main_detail_id FROM main_detail WHERE main_detail_id
= "+this_main_detail_id;
var rs = db.execute('SELECT main_detail_id,staff_notes FROM main_detail '+
'where main_detail_id = ? and staff_notes != ?',
[$this_main_detail_id, ' ']);
This_main_detail_id is not coming up with the value. If I just output the
parameter the value is there. What am I doing wrong?
Thanks in advance.
meerkat
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
