function showRecords2() {  
   
                           var firstName2 = document.getElementById('f
+irstName22').value;  
                    results4.innerHTML = '';
        db.transaction(function(tx4) {
          //tx.executeSql(selectAllStatement2, [], function(tx, result
+) {
         //var firstName2 = document.getElementById('firstName22');  
        
         //tx.executeSql('SELECT * FROM Strokes WHERE email = ?', [ema
+il], renderResults);
        // tx4.executeSql('SELECT     *  FROM Contacts  WHERE firstNam
+e="Joo" ', [], function(tx4, result4) {
    tx4.executeSql('SELECT     *  FROM Contacts  WHERE firstName="' + 
+firstName2 + '" ', [], function(tx4, result4) {
         dataset = result4.rows;
          // report(result.rows[0].firstName, result.rows[0].lastName)
+;
            for (var i = 0, item = null; i < dataset.length; i++) {
              item = dataset.item(i);
               results4.innerHTML +='<table width="320" border="7"><tr
+> <td style="font-size:18px" width="90">' + item['id'] + '</td>'     
++ '<td width="30" style="font-size:17px">' + item['lastName'] + '</td
+>' + '<td>' +
                  '<a href="#" onclick="loadRecord('+i+')">Edit -- </a
+>   ' + '</td>' + '<td>'  +   '<a href="#" onclick="deleteRecord('+it
+em['id']+')">Delete</a></td></tr></table>';
     //results.innerHTML += 
                //  '<li>' + item['lastName'] + ' , ' + item['firstNam
+e'] + ', ' + item['phone'] + '----------- <a href="#" onclick="loadRe
+cord('+i+')">edit</a></li>';
            }
            
            });
        });

[download]

In reply to Re^4: DBD::SQLite, how to pass array in query via placeholder? by Anonymous Monk
in thread DBD::SQLite, how to pass array in query via placeholder? by dwalin

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.