How to get the result from a query function reside in another file? (Javascript, phoneGap and Sqlite)

Question

I wanted to separate my main.js file from my sqlite function file. How can I get the result of the query to the main.js (fr anotherFile.js).

//In main.js
function getResult() {
    queryDB(); //how to get d result from queryDB() ?
}

// In anotherFile.js:
function queryDB(tx) {
    tx.executeSql('SELECT * FROM DEMO', [], onSuccess, onError);
}

function onSuccess(tx, results) {
    for (var i=0; i<result.length; i++) { 
        //what to put here, Array?
    }
}

thanks.

gaepi · Accepted Answer · 2013-07-11 10:25:08Z

1

//anotherFile.js:

function queryDB(tx, callbackMethod) {
    tx.executeSql('SELECT * FROM DEMO', [], callbackMethod, onError);
}

//main.js

function sendQuery() {
    queryDB(tx, queryResult);
}

function queryResult(tx, results) {
    for (var i=0; i<result.length; i++) { 

    }
}

answered Jul 11, 2013 at 10:25

gaepi

4043 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jameslcs Over a year ago

thanks for the answer, i found out that i can just cut n paste any function into another file. It will works just fine.

Collectives™ on Stack Overflow

How to get the result from a query function reside in another file? (Javascript, phoneGap and Sqlite)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related