[sqlite] binding parameters

[meerkat]

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