Friday, 28 April 2017

Error: Can't set headers after they are sent

Query run successfully but Server closed And it give following error

Error: Can't set headers after they are sent.
at ServerResponse.OutgoingMessage.setHeader (_http_outgoing.js:356:11)

As I find it send response on per loop that is the main reason. So my question how to send response after completing the loop? Advanced Thanks.

    var addVenueAmenities = function(req, res) {
    var post={
    venue_id:req.params.venue_id,
    amenitie:req.body.amenitie
}


for(i=0;i<post.amenitie.length;i++){

data={
venue_id:post.venue_id,
amenitie:post.amenitie[i]
}

var query = "INSERT INTO  ?? SET  ?";
        var table = ["venue_amenities"];
        query = mysql.format(query,table);
        connection.query(query, data, function(err,rows){
            if(err) {

             res.json({"Error" : true, "Message" : "Error executing MySQL query"});
            } else {

             res.json({"Error" : false, "Message" : "Amenitie  added successfully"});

            }
        });
}
} 
 module.exports= addVenueAmenities;



via Akhilendra yadav

No comments:

Post a Comment