Tuesday, 23 May 2017

MySQL query returns empty array in nodejs, but fullfilled in SQL tool

F.e. I have a queries to get data by id -- INT(11): 1) select * from users where id = 1234 2) select * from users where id = 123456 These two queries returns relevant data in sql tool like Workbench, but when it takes to process these queries via nodejs/cleardb/expressjs app first one returns relevant data, but second one always returns empty array. I've tried to db-escape numbers, convert them to strings, but it didn't work.



via Aleks Maksiuta

No comments:

Post a Comment