<script language="JavaScript" src="SQLite3.js"></script>
<script language="JavaScript">
function displayLargeCities()
{
    var myDB = new JNEXT.SQLite3();
    myDB.open( "data.db3" );
    var strHTML = ""; var nMinPop = 50000;
    var strQuery = "select * from cities where population > " + nMinPop;
    var objQuery = myDB.query( strQuery );
    var arNames = objQuery.getColNames(); // Will hold column names
    var arTypes = objQuery.getColTypes(); // Will hold column types
    var strHTML = "<table>";
    var row;
    while ( (row = objQuery.getRow()) != null ) // Get next row contents
    {
        strHTML += "<tr>";
        for ( var i=0; i<row.length; i++ )
        {   // populate table row
            strHTML += "<td>" + row[ i ] + "</td>";
        }
        strHTML += "</tr>";
    }
    strHTML += "</table>";
    document.GetElementById( "idDispTable" ).innerHTML = strHTML;
}
</script>