Select from event on client

Question

Select from event on client

iuraya opened this issue 9 years ago · 1 comments

Hi,

I'm trying to do a select from the client to retrieve some info but nothing happens in the callback of the method call:

Client side:
Template.register.events({
'submit form': function(event) {
event.preventDefault();
var email = $('[name="email"]').val();
Meteor.call('test', email, function(error, result) {
if (error) {
console.log(error);
}
else {
alert ('done');
}
});
}
});

Server side:
Meteor.methods ({
'test': function(email) {
return liveDb.select(
'SELECT * FROM users WHERE email = ' + liveDb.db.escape(email),
[
{
table: 'users',
condition: function(row, newRow, rowDeleted) {
return row.email === email || (newRow && newRow.email === email);
}
}
]
);
},
});

Also I would like to ask if I can place a subscription on the router. I've tryied this:
Router.route('/register', {
name: 'register',
template: 'register',
waitOn: function () {
return new MysqlSubscription('users');
}
});

Thank you very much

Answer 1 · 2015-10-17T15:41:55.000Z

It is no use to return a LiveMysqlSelect object from a Meteor method. Either change it to a publication for live updates or if you want to retrieve the results from a query just once, return the results using liveDb.db.query() as defined by node-mysql.