TypeError while iterating over an loop in NodeJS

Question

I'm trying to write my database-data to a JSON. It works when I do not use the loop.

Then I get: TypeError: first argument must be a string or Buffer

I'm using the mysql npm package.

con.query('SELECT * FROM mydb.orders_view;', function(err, rows, fields) {
            if (err) {
                res.status(500).json({ result: 'Error' })
            }
            for (var i = 0; i < rows.length; i++) {

                 res.write(
                 {
                time: date,
                Order: [{
                    OrderedBy: rows[i]['OrderedBy']
                }]
               } 
            );
                }

            res.end();


        });
});

T.J. Crowder · Accepted Answer · 2015-10-05 09:41:46Z

4

You're calling write with an object. According to the documentation, it must be a string or buffer:

chunk can be a string or a buffer. If chunk is a string, the second parameter specifies how to encode it into a byte stream. By default the encoding is 'utf8'. The last parameter callback will be called when this chunk of data is flushed.

Side note: You're not handling the error case properly, you probably want a return; in that initial if block so you don't continue to the loop when an error occurs.

answered Oct 5, 2015 at 9:41

T.J. Crowder

1.1m201 gold badges2k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

frontender_amsterdam Over a year ago

Thank you. I improved my error handling. Fixed the issue by using res.write(JSON.stringify).

Collectives™ on Stack Overflow

TypeError while iterating over an loop in NodeJS

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related