Re: DBD::Pg problem - Mailing list pgsql-general
From | Barbara Lindsey |
---|---|
Subject | Re: DBD::Pg problem |
Date | |
Msg-id | 3FCDE437.9060309@cog.ufl.edu Whole thread Raw |
In response to | Re: DBD::Pg problem ("Ausrack Webmaster" <webmaster@ausrack.com.au>) |
Responses |
Re: DBD::Pg problem
|
List | pgsql-general |
When I have problems like this, I do something like this: $sql="insert into it_contact (email, to_email, subject,details,modify,parent) values( '".$from."','".$to,"','".$subject."','".$body."', now(),'".$parent."')"; Then you dont have to bind params. You can just prepare and execute. Besides that, you can print the $sql string with the expanded variables and copy and paste it into psql to see if that gets you a different error to help debug if it is not already obvious when you see the whole SQL. Hope this helps. Barb usrack Webmaster wrote: > The thing is...I am not. I am inserting it into a varchar field. > > $sql="insert into it_contact (email, to_email, subject, > details,modify,parent) values(?,?,?,'$body',now(),'$parent')"; > $sth = $dbh->prepare($sql); > $sth->bind_param(1, $from, {pg_type => DBD::Pg::PG_TEXT}); > $sth->bind_param(2, $to, {pg_type => DBD::Pg::PG_TEXT}); > $sth->bind_param(3, $subject, {pg_type => DBD::Pg::PG_TEXT}); > $sth->execute; > > \d it_contact; > Table "public.it_contact" > Column | Type | > Modifiers > ------------+-----------------------------+----------------------------- > --------------------------------------- > contact_id | integer | not null default > nextval('public.it_contact_contact_id_seq'::text) > email | character varying(100) | > to_email | character varying(100) | > subject | text | > fname | character varying(30) | > lname | character varying(30) | > kafname | character varying(30) | > kalname | character varying(30) | > details | text | > modify | timestamp without time zone | > status | smallint | > parent | integer | > > > Jason > > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Martijn van > Oosterhout > Sent: Wednesday, December 03, 2003 3:52 PM > To: Ausrack Webmaster > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] DBD::Pg problem > > > 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: > >>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 >>"<support@somedomain.com>": can't parse "<support@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 > > -- Barbara E. Lindsey, COG RDC Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162 ---- CONFIDENTIALITY NOTICE: The information contained in this electronic message is legally privileged and confidential and intended only for the use of the individual(s) or entity(ies) named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this email or any of it's components is strictly prohibited. If you have received this email in error, please contact the sender. ----
pgsql-general by date: