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');
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.
Comments