gistfile1.txt

var inmomentNameSpace = angular.module('inmoment', []);
inmomentNameSpace.controller('sampleController', function sampleController($scope,$timeout){
    $scope.cats = [];
    db.transaction (
        function(tx) {
            $("#catList").empty();
            /* what's the hack is going on here ! 
             * In the angularjs world is strictly forbidden
             * using reference to dom in the controller :)
             * Go with a directive instead.
             * Possible don't use jquery at all
             * but using like angular.element("#catList").empty();
             * https://docs.angularjs.org/api/ng/function/angular.element
             * if in the directive you have got the reference to the element
             * you can do simple element.empty()
             */
            tx.executeSql('SELECT CATEGORY.catID, CATEGORY.Title, CATEGORY.image, COUNT(SUBCATEGORY.subID) as cCount, COUNT(MESSAGETB.mesID) as mCount, SUBCATEGORY.title, SUBCATEGORY.catID FROM CATEGORY LEFT OUTER JOIN SUBCATEGORY ON CATEGORY.catID = SUBCATEGORY.catID LEFT OUTER JOIN MESSAGETB ON SUBCATEGORY.subID = MESSAGETB.subID GROUP BY CATEGORY.catID ORDER BY CATEGORY.Title ASC', [], 
                function (tx, results) {
                    var len = results.rows.length;
                    var catObj = [];
                    for(var i = 0; i<len; i++) {
                        catObj[i] = results.rows.item(i);
                    }
                    console.log(catObj);
                    $timeout(function(){
                        $scope.cats = catObj;
                    });
                    // using $timeout like above
                    // is a little hack to trigger
                    // a $digest cycle
                }
            );      
        }
    );
});