I am using node oracle to* connection.execute("SELECT alot of stuff FROM 
inventory")*. So I took all my original sql files and I put them in a 
folder. Now I want to use node to read the file contents and do * 
connection.execute(function(inventory.sql)) 
*where in the sql file is my select. Some of the queries have three table 
joins so it make the code look messy and it just seems more organize. Below 
is what I have so far but I just can not get it working! Thanks


fs = require('fs');
var select_statement = "";
var sql_file = function(value) {
    fs.readFile('./SQLs/inventory.sql', 'utf8', function(err, data) {
        if (err) {
            return console.log(err);
        };
        return data.toString();
    });
    //return value //+ select_statement;
};
module.exports.select_statement = select_statement;
module.exports.sql_file = sql_file;

-- 
-- 
Job Board: http://jobs.nodejs.org/
Posting guidelines: 
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to nodejs@googlegroups.com
To unsubscribe from this group, send email to
nodejs+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en

--- 
You received this message because you are subscribed to the Google Groups 
"nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nodejs+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to