MYSQL X DEV API Update method not working

Question

I could not find a good template for the update method for the xdevapi library and thought maybe some one could help me out with getting this to work.

acts_table
    .update()
    .set('account_status', 'new account status')
    .where('customer_number like :customer_number && original_account_number like :original_account_number')
    .bind('01234588456')
    .bind('12156464645')
    .execute()

I think its just a formatting issue, but with no real examples in the XDEVAPI Documentation for update for Javascript I'm kind of at a lost. Please help. The error I get is Cannot Read property 'toArray' of undefined.

nmsdev · Accepted Answer · 2021-03-03 05:28:30Z

0

It was formatting, in the bind method I forgot to put the fields we were binding so the answer is this:

acts_table
    .update()
    .set('account_status', 'new account status')
    .where('customer_number like :customer_number && original_account_number like :original_account_number')
    .bind('customer_number','01234588456')
    .bind('original_account_number', '12156464645')
    .execute()

answered Mar 3, 2021 at 5:28

nmsdev

296 bronze badges

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

Collectives™ on Stack Overflow

MYSQL X DEV API Update method not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related