I'm using a node ws server built on einaros/ws. That server has to send queries to a database. For that i'm using felixge/node-mysql.  When a user connects to the server, it should be checked if the client still exists in the database.  Here...
I'm getting parse errors when I try to use node-mysql to invoke a query on a MYSQL database. I'm pretty sure that the query works. It runs without doubt via phpmyadmin.  Message.save = function(message, callback){     db.query("INSERT INT...
I'm using mysql connection pool to create connection. The code looks like the following.  var pool = mysql.createPool(connectionProps);   by accessing pool, I'll get the an Object, even if the connection is not Successful. I checked it with s...
I am looking at some examples in node-mysql https://github.com/felixge/node-mysql  I am confused over when to use ?? and ? as placeholders in constructing a query.  An example is here;  var userId = 1; var columns = ['username', 'email...
I would like to store result from mysql query in an array ( docAutocomplete) and after all the query completed I wanted to see the final array. I am using async series for this purpose. The issue is the array doesn't print anything as it looks li...
I have this mysql query written in node.js mysql and restify to be executed in a HTTP GET.  https://github.com/felixge/node-mysql  var api_get_func = function (app, url_path) {     function respond(req, res, next) {         var id= req.query.id;...
I'm a newbie in Javascript and I was trying to make a function to return an array of itens that I got from my DB. First I tried this:  function getItens(userId){      var arr = new Array;     var result;     var connection = mysql.createConnectio...
I have to pump lines from an input file, transform them and put them in an output file.  Since, the input file is huge, I stream it thanks to HighlandJS.  Transformation step includes async queries in MySQL DB (via node-mysql) and I can't find ou...
SECOND EDIT  The issue was caused by the MAX_INTEGER_VALUE which is lower then the integer value I was passing. I changed the MySQL table column to TEXT instead of BIGINT and everything is being returned correctly.  Thanks for all the help!  EDIT  So...
I am able to run sql query and fetch records from MySql database using the following code  var mySql = require("mysql");  var connection = mySql.createConnection({   host : "localhost",   user : "root",   password : "rahul...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.