MEMSQL returing undefined results


#1

I am trying to query results from my MEMSQL database, and have been unsuccessful.
Once the application starts i get an error stating" The solution is undefined" , followed by the
results i’m trying to query.

The results show up in the console log, but not in the actual application.

Ive attached a copy of my code below:

connection.connect(function(err){

if (err) throw err
});

function getTeams(callback){

var results = connection.query(‘SELECT ID, NAME FROM TEAM’,function(err, results, fields){

if (err) throw err
//console.log(results);
console.log('The solution is: ', results[0].solution);

return callback(results);
});
}

Your help will be greatly appreciated.


#2

I’m not familiar with this area, but for someone to help, it’ll help to know the application programming language & version, OS version, MemSQL version, driver name, and driver version.


#3

Your query doesn’t select a “solution” field, so that’s why results[0].solution would be undefined.