truncated incorrect double (nodejs)

Christian Angelo M Sulit

I am getting

truncated incorrect double value error

when running

var post = {ip:'10.90.0.203'};
con.query("UPDATE ipaddress SET flag = 1,status = 'up' WHERE ip = ?",post);

this is my table structure

create table ipaddress(
ip varchar(15) unique not null,
flag smallint default 0,
status varchar(5) default 'down');
Rafalsonn

I think it should be done that way:

con.query("UPDATE ipaddress SET flag = 1,status = 'up' WHERE ip = ?",post.ip);

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

MYSQL Truncated incorrect DOUBLE value

Truncated incorrect DOUBLE error in MySQL

MYSQL Truncated incorrect DOUBLE value: Upon multiplying

Truncated incorrect DOUBLE value mysql stored procedure

Truncated incorrect DOUBLE value: 'hello.world'

MySql Error: Truncated incorrect DOUBLE value

Data truncation:Truncated incorrect Double value

Truncated incorrect DOUBLE value using DELETE statement

Mysql error: Truncated incorrect DOUBLE value: 'world'

Error Code: 1292 - Truncated Incorrect DOUBLE value: '-'

Truncated incorrect DOUBLE value error on SQL statement?

MYSQL Truncated incorrect DOUBLE while using double and single quotation marks

Error Code 1292 - Truncated incorrect DOUBLE value - Mysql

Data truncation: Truncated incorrect DOUBLE value: '3ML80909540'

How to fix Truncated incorrect DOUBLE value: 'undefined' error

Select Query: Error Code 1292 - Truncated incorrect DOUBLE value

getting Error Code: 1292 Truncated incorrect DOUBLE value in stored procedure?

PDO error "Truncated incorrect DOUBLE value" using placeholder

Error Code: 1292. Truncated incorrect DOUBLE value: 'xxx'

MySQL Truncated incorrect DOUBLE value: 'string' in Java Spring Repository

getting warning of 1292 Truncated incorrect DOUBLE value using IN operator in mysql

How to avoid implicit conversion of MySQL (Truncated incorrect DOUBLE value)

Python/MySQL: "Truncated incorrect double value..." on a simple text insert

MEANING OF ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'JAIN'

Error Code: 1292. Truncated incorrect DOUBLE value

SQL: 1292 Truncated incorrect DOUBLE value: 'https://twitter.com/'

SQL - MariaDB : SQL Error 1292 Truncated incorrect DOUBLE value

Twig incorrect truncated html

MySQL: ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'col1', computed virtual column insert