Tuesday, 16 July 2019

Sequelize query not returning anything but direct mysql does.

const str = "SELECT *, DistanceInMiles(41.02444987, -72.48162863, z.lat, z.lng) as distance from restaurants z WHERE z.lat BETWEEN 40.52444987 AND 41.52444987 AND z.lng BETWEEN -72.88162863 AND -72.08162863 HAVING distance < @dist ORDER BY distance LIMIT 10";sequelize.query(str).catch((err) => (console.log(err.message))).then(res =>{console.log(res);});console.log(res) shows [ [], [] ] on the console, but the actual query works in mysql

Submitted July 17, 2019 at 12:34AM by BensonandEdgar

No comments:

Post a Comment