{"id":86,"date":"2013-07-15T11:05:00","date_gmt":"2013-07-15T02:05:00","guid":{"rendered":"https:\/\/www.picolix.jp\/blog\/2013\/07\/dbdpgst-execute-failed-error-invalid.html\/"},"modified":"2019-04-02T10:26:53","modified_gmt":"2019-04-02T01:26:53","slug":"dbdpgst-execute-failed-error-invalid","status":"publish","type":"post","link":"https:\/\/www.picolix.jp\/blog\/2013\/07\/dbdpgst-execute-failed-error-invalid.html","title":{"rendered":"DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: “”"},"content":{"rendered":"

\u3068\u3042\u308b\u691c\u7d22\u30c7\u30fc\u30bf\u4f5c\u6210\u4e2d\u3067\u3059\u3002<\/p>\n

perl\u306eDBD\u5229\u7528\u3067\u306e\u3001postgres\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306einteger\u3078\u306eNULL\u5024\u306einsert\u30a8\u30e9\u30fc\u3067\u3059\u304c\u3001\u4ee5\u524d\u306f\u3001
\n\uff1d\uff1d\uff1d\uff1d
\n\u4f8b\uff09
\ndummy\u8868:
\n no integer
\n name character varying
\n level intger
\n\uff1d\uff1d\uff1d\uff1d<\/p>\n

$insert = “insert into dummy (no,name,level) values (?,?,?)”;
\n$sth_insert = $dbh->prepare($insert);
\n$data = “null”;\u3000#\u3068\u304b\u3001$data = “”\u3067\u3082\u3044\u3051\u305f\u6642\u3082\u3042\u3063\u305f\u3002
\n$sth_insert->bind_param(1,”TEST”,$data);
\n$sts = $sth_insert->execute();<\/p>\n

\u3067\u3001bind_param\u306e\u65b9\u3067\u3001NULL\u5224\u65ad\u3057\u3066\u304f\u308c\u3066intger\u306bNULL\u5024\u304c\u5165\u3063\u3066\u304f\u308c\u3066\u305f\u306e\u306b\u3053\u308c\u3060\u3068\u30a8\u30e9\u30fc\u3059\u308b\u3002
\n\u5f53\u7136\u3001$data = “”\u3067\u306f\u3060\u3081\u3067\u3001\u7d50\u5c40 $data = undef;
\n\u3068\u3057\u3066\u3001\u5909\u6570\u305d\u306e\u3082\u306e\u3092undef\uff08\u672a\u5b9a\u7fa9\u5024)\u306b\u3057\u3066\uff2f\uff2b\u3068\u306a\u3063\u305f\u3002<\/p>\n

\uff0a\u81ea\u5206\u304c\u4f7f\u3063\u3066\u308bphpPgAdmin\u3082\u30c7\u30fc\u30bf\u633f\u5165\u3067\u3001intger\u9805\u76ee\u672a\u5165\u529b\u3060\u3068””\u30a8\u30e9\u30fc\u3068\u306a\u308b\u3002
\n\u3044\u3064\u304b\u3089\u3053\u3093\u306a\u3053\u3068\u306b\u3002PostgreSQL 8.?\u4ee5\u964d\u304b\u3089\u3002\u65e7\u30b7\u30b9\u30c6\u30e0\u304b\u3089\u306e\u79fb\u884c\u3059\u308b\u3068\u304d\u6ce8\u610f\u304c\u5fc5\u8981\u30fb\u30fb<\/p>\n","protected":false},"excerpt":{"rendered":"

\u3068\u3042\u308b\u691c\u7d22\u30c7\u30fc\u30bf\u4f5c\u6210\u4e2d\u3067\u3059\u3002 perl\u306eDBD\u5229\u7528\u3067\u306e\u3001postgres\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306einteger\u3078\u306eNULL\u5024\u306einsert\u30a8\u30e9\u30fc\u3067\u3059\u304c\u3001\u4ee5\u524d\u306f\u3001 \uff1d\uff1d\uff1d\uff1d \u4f8b\uff09 dummy\u8868:  no integer & … <\/p>\n

“DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: “”” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/86"}],"collection":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/comments?post=86"}],"version-history":[{"count":1,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/86\/revisions"}],"predecessor-version":[{"id":1316,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/posts\/86\/revisions\/1316"}],"wp:attachment":[{"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/media?parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/categories?post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.picolix.jp\/blog\/wp-json\/wp\/v2\/tags?post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}