Update query using object

Question

I'm using npm package mysql and I want to do an update query that gets an object and knows what are the fields that need an update

function editPlaylistDB(publicID, name, description,callback) {

    let insertData={};
    if (name!==null){
        insertData.name=name;
    }
    if(description!==null){
        insertData.description=description;
    }

     db.query('update playlists set name=insertData.name,description=description  WHERE public_id= ?',[publicID]).then((rows=>{
        console.log(rows);
        callback(rows);

    })).catch((err)=>{
        console.log(err);
        callback(null);
    });
}

This is the error message

Error: ER_BAD_FIELD_ERROR: Unknown column 'insertData.name' in 'field list'

I don't know if it is even possible.

Rob Nice · Accepted Answer · 2019-02-12 15:34:39Z

1

Why not add another parameterized variable like the public_id? Also, it looks like your description was not being set correctly either. Also, double check how you are setting insertData.description and where that should go.

db.query('update playlists set name=?,description=?  WHERE public_id= ?',[insertData.name, (description var goes here), publicID]).then((rows=>{
    console.log(rows);
    callback(rows);

})).catch((err)=>{
    console.log(err);
    callback(null);
});

answered Feb 12, 2019 at 15:34

Rob Nice

2981 silver badge5 bronze badges

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

1 Comment

Rob Nice Over a year ago

Updated, looks like your description column was not being set correctly either.

Guseyn Ismayylov · Accepted Answer · 2019-02-12 16:11:47Z

0

Maybe you need to use parameterised string:

`update playlists set name=${insertData.name},description=${description}  WHERE public_id= ?`

answered Feb 12, 2019 at 16:11

Guseyn Ismayylov

3935 silver badges16 bronze badges

Collectives™ on Stack Overflow

Update query using object

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related