Display random values From Sqlite Database Using JavaScript

Question

I'm using Cordova Database and I have to display my images in the database randomly. Sqlite order by Random() is not working ... Here is my code

Var myDB = window.openDatabase("Database", "1.0", "Cordova Demo",10485760);
myDB.transaction(function(transaction) {

    transaction.executeSql('SELECT * FROM YOUTUBE_VIDEOO ORDER BY RANDOM LIMIT 6 ', [], function(tx, res){
        for(var iii = 0; iii < res.rows.length; iii++)
        {
            $('#uTubeLst').append("<div style='float:left;padding:10px;'><img src ='data:image/png;base64,"+res.rows.item(iii).imgSRc+"' width=40 height=50  ></div>");
        }

        function(transaction){

            var $lastNo = "";
        }
    }, null);
});

score 2 · Answer 1 · edited May 23 '17 at 10:29

2

I think you have to use braces because RANDOM() is a function, so your query string would look something like

'SELECT * FROM YOUTUBE_VIDEO ORDER BY RANDOM() LIMIT 6'

UPDATE

This seems to have a really poor performance, look at this thread for informations and alternatives: Select random row(s) in SQLite

edited May 23 '17 at 10:29

Community

1
1

answered Jun 21 '16 at 07:16

xaggre

128
6

Display random values From Sqlite Database Using JavaScript

1 Answers1