[00:00] Phoenixz: heavyUser: Since there are many projects with "mysql",. maybe I have the wrong one.. Could you give me the node package name, or better, a URL where I could find the one you are using? [00:00] joeytwiddle has joined the channel [00:00] heavyUser: felixge/node-mysql [00:01] Phoenixz: heavyUser: Thats the one I have.. 0.9.5 should be the latest.. But what do you mean with .once and .on ? [00:01] heavyUser: i mean this: [00:01] heavyUser: Phoenixz: im using this syntax: var query = sql.query('some query here'); query.on('row', function(row) { console.log(row); }); query.on('end', function() { /* we have it all */ }; [00:01] arturoml has joined the channel [00:01] heavyUser: or, if its an INSERT/UPDATE query, then i would use this: [00:01] Phoenixz: heavyUser: Let me try that then.. [00:02] hotchkiss has joined the channel [00:02] Phoenixz: heavyUser: So you are not using a callback function? [00:02] heavyUser: sql.query('some UPDATE/INSERT query here', function(error, info) { if(err) throw err; console.log(info); }); // try this out [00:02] heavyUser: Phoenixz: i am using a callback function [00:02] heavyUser: im just assigning it the other way [00:02] heavyUser: a callback for every row [00:03] heavyUser: try it out you'll understand [00:04] Phoenixz: heavyUser: tryin... [00:05] heavyUser: ok [00:06] Phoenixz: heavyUser: http://pastebin.com/u0NDhHDJ Still not working [00:06] Phoenixz: This is a quick test case I wrote [00:06] shinuza has joined the channel [00:06] boltR has joined the channel [00:06] Phoenixz: (And I suppose 'end' has no parameters, but I added one just to see [00:06] Phoenixz: ) [00:07] kbhit has joined the channel [00:07] Phoenixz: heavyUser: http://pastebin.com/9rF1rAit This is the result that I get [00:07] joshfinnie has joined the channel [00:07] kbhit has joined the channel [00:08] Bonuspunkt has joined the channel [00:09] heavyUser: 1 sec [00:09] agnat_ has joined the channel [00:09] jj0hns0n_ has joined the channel [00:09] bnoguchi has joined the channel [00:09] tmcw has joined the channel [00:10] heavyUser: Phoenixz: all seems good except that i dont use the createClient call [00:10] heavyUser: try this way [00:10] boltR has joined the channel [00:11] Phoenixz: heavyUser: Maybe that's the problem? :( [00:11] heavyUser: wait 1 sec i'll check my latest code just to be sure [00:11] heavyUser: im using sql.connect() [00:12] Phoenixz: heavyUser: err... Documentation kinda.. is incomplete, to state it nicely.. Any examples out there? [00:12] mikeal has joined the channel [00:13] heavyUser: do this: mysql = require('mysql'); mysql.host = 'localhost; mysql.user = 'pladeo'; mysql.password = 'pladeo'; mysql.connect(function(){ /* this function gets called when you're connected */ }); [00:13] heavyUser: i have some typos there but you get the point [00:13] RiverraiD has joined the channel [00:14] heavyUser: you require the module, set the host, user and password. the call the .connect() function that takes 1 argument, the callback to be executed when sql connection is ready [00:14] Phoenixz: OKay, okay.. rewriting... [00:14] heavyUser: inside that callback, place your queries like you showed in the pastebin [00:14] kbhit has joined the channel [00:15] nibblebo_ has joined the channel [00:15] heavyUser: i agree that the documentation around all the node.js stuff is very raw [00:16] kbhit has joined the channel [00:16] Phoenixz: heavyUser: TypeError: Object #