DBD :: Pg问题 [英] DBD::Pg problem

问题描述

嗨


我想在文本字段中插入一个简单的电子邮件地址，

我收到以下错误：


DBD :: Pg :: st执行失败：错误：pg_atoi：错误

"< su ***** @ somedomain.com>"：can 't parse"< su ***** @ somedomain.com>"


我认为这是因为<和@中的值，但是为什么这些作为运算符甚至

当值有单引号时呢？

我有甚至尝试预先绑定值和PG_TEXT仍然

不运气。


任何帮助将不胜感激。


Jason Frisch


---------------------------（播出结束） - -------------------------

提示4：不要杀死-9''邮政局长

Hi

I am trying to insert a simple email address into a text field,
and I get the below error:

DBD::Pg::st execute failed: ERROR: pg_atoi: error in
"<su*****@somedomain.com>": can''t parse "<su*****@somedomain.com>"

I figure it is because of the < and @ in the value, but why does it take
these as operators even
when the value has single quotes around it?
I have even tried binding the values and PG_TEXT beforehand and still
not luck.

Any help would be greatly appreciated.

Jason Frisch

---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster

推荐答案

pg_atoi是int转换器的字符串。你想把它插入一个

整数字段。


2003年12月3日星期三03:45:53 PM +0900，Ausrack网站管理员写道：

pg_atoi is the string to int converter. You''re trying to insert it into an
integer field.

On Wed, Dec 03, 2003 at 03:45:53PM +0900, Ausrack Webmaster wrote:

嗨

我想在文本字段中插入一个简单的电子邮件地址，
我收到以下错误：

DBD :: Pg :: st执行失败：错误：pg_atoi：
中的错误"< su ***** @ somedomain.com>"：无法解析"< su ***** @ somedomain.com>"

我认为这是因为<和@中的值，但为什么当这个值有单引号时，它们就像运算符一样？
我甚至尝试过预先绑定值和PG_TEXT并且仍然是
任何帮助将不胜感激。

Jason Frisch


------------------------ ---（播出结束）---------------------------
提示4：不要杀 - 9''邮政局长


-

Martijn van Oosterhout< kl ***** @ svana.org> http://svana.org/kleptog/ 部队所需要的一切邪恶胜利是为了让人无所作为。 - 爱德蒙伯克
好人为不参与政治而付出的代价是由比自己更糟糕的人管理。 - 柏拉图

Hi

I am trying to insert a simple email address into a text field,
and I get the below error:

DBD::Pg::st execute failed: ERROR: pg_atoi: error in
"<su*****@somedomain.com>": can''t parse "<su*****@somedomain.com>"

I figure it is because of the < and @ in the value, but why does it take
these as operators even
when the value has single quotes around it?
I have even tried binding the values and PG_TEXT beforehand and still
not luck.

Any help would be greatly appreciated.

Jason Frisch



---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ "All that is needed for the forces of evil to triumph is for enough good
men to do nothing." - Edmond Burke
"The penalty good people pay for not being interested in politics is to be
governed by people worse than themselves." - Plato

----- BEGIN PGP SIGNATURE -----

版本：GnuPG v1.0.6（GNU / Linux）

评论：有关信息，请参阅 http://www.gnupg.org


iD8DBQE / zYgKY5Twig3Ge + YRArVDAJ0YqO4Ua0jeiLz0xyYPLU74yqcoiQ CdHq2G

pTH9QrMtdFGDdpYj3DpixAI =

= KGnB

- ---结束PGP签名-----

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/zYgKY5Twig3Ge+YRArVDAJ0YqO4Ua0jeiLz0xyYPLU74yqcoiQ CdHq2G
pTH9QrMtdFGDdpYj3DpixAI=
=KGnB
-----END PGP SIGNATURE-----

事情是......我不是。我将它插入varchar字段。

The thing is...I am not. I am inserting it into a varchar field.

sql =" insert into it_contact（email，to_email，subject，

细节，修改，父母）值（？，？，？，''

sql="insert into it_contact (email, to_email, subject,
details,modify,parent) values(?,?,?,''

这篇关于DBD :: Pg问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！