module export mySQL - ReferenceError: connection is not defined

[jeg]

Hi all,

error message when match.js is called with  insert

thanks 

Eric

match.js:53

          connection.query('insert into MYTABLE set ' + wREQUEST, function(err, res) {

          ^

ReferenceError: connection is not defined

***

main.js

var request = require('request');

var cheerio = require('cheerio');

var mysql      = require('mysql');

var connection = mysql.createConnection({

  host     : 'localhost',

  user     : 'admin',

  password : 'secret',

  database : 'mydb'

});

connection.connect();

request('http://url/en', function (error, response, html) {

  if (!error && response.statusCode == 200) {

    var $ = cheerio.load(html);

    $('div.expander-button').each(function(i, element){

      var a = $(this);

      var zurl = a.next().children().children().attr('href');

      // Our parsed meta data object

      var metadata = {

url: zurl

      };

      //console.log(zurl);

 var a = require('./match')(zurl);

 a.extractValue();

    });

  }

});

connection.end();

***

match.js

module.exports = function(zurl) {

  return {

  extractValue: function() {

....

....

....

 

 connection.query('insert into MYTABLE  set ' + wREQUEST, function(err, res) {

      if (err) throw err;

 } ) ;

 

[Emanuele DelBono]

connection is defined in main.js not in match.js

Modules isolate the scope of the variables.

Since match.js exports a function you can pass the connection to the function.

--
Job board: http://jobs.nodejs.org/
New group rules: https://gist.github.com/othiym23/9886289#file-moderation-policy-md
Old group rules: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
---
You received this message because you are subscribed to the Google Groups "nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nodejs+un...@googlegroups.com.
To post to this group, send email to nod...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nodejs/38690d8e-9440-4cbd-bcf3-3b72e892eb98%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

ema
http://ema.codiceplastico.com

[jeg]

it's works well

Thanks Ema