How to insert/update with NULL value in Node.Js
Hii
I want to use Connector for Node.Js which is using xdevapi.
I want use following scenario.
table.insert(['name','isActive']).values([null, 1]).execute();
problem here is that I can't insert null value. It gives me error.
Error: invalid input expression
at module.exports (D:\CodeBase\GitKraken\BitBucket\MSSP\Vue\vue-apexa-portal\node_modules\@mysql\xdevapi\lib\DevAPI\Util\parseFlexibleParamList.js:43:15)
at Object.values (D:\CodeBase\GitKraken\BitBucket\MSSP\Vue\vue-apexa-portal\node_modules\@mysql\xdevapi\lib\DevAPI\TableInsert.js:106:28)
at Object.InsertData (D:\CodeBase\GitKraken\BitBucket\MSSP\Vue\vue-apexa-portal\src\server\database.js:115:8)
at <anonymous>
at process._tickCallback (internal/process/next_tick.js:188:7)
Can anyone help me with this?
Subject
Written By
Posted
How to insert/update with NULL value in Node.Js
November 23, 2018 02:50AM
November 28, 2018 08:22AM
November 28, 2018 08:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.