execute is not working

[nishit321]

When I use prepared statements then it won't work. But I work for query(). Please check the below code.

pool.execute('call usp_update_company_profile_step_1(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);', [
  100,
  null,
  '[{"Address":""}]',
  'sa',
  0,
  undefined,
  undefined,
  undefined,
  undefined,
  '<p>as</p>',
  '[{"item_id":1,"item_text":"Banks and Insurances"}]',
  'as',
  1
], (err, rows: any, cols) => {
                if (err) return reject(err);
                console.log('rows', rows);
                rows = this.removeByKey(rows, {
                    key: 'protocol41',
                });
                const result: T =
                    rows.length > 1
                        ? JSON.parse(JSON.stringify(rows[0]))
                        : JSON.parse(JSON.stringify(rows[0][0]));
                resolve(result);
            });

And above code works fine in query().

[sidorares]

can you try replacing undefined with null? There is no undefined mysql type and as a result no mapping from undefined js prameter

With your example - do you get any errors? Can you describe how it "won't work" with .execute() ?

[sidorares]

I'll try to practice converting "likely just a question" types of issues into a discussions and see how it goes.