Re: DBD::Pg problem - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: DBD::Pg problem
Date
Msg-id 3FCE13F1.8060307@commandprompt.com
Whole thread Raw
In response to DBD::Pg problem  ("Ausrack Webmaster" <webmaster@ausrack.com.au>)
List pgsql-general
Hello,

  I don't have your code but I think you are using "do" instead of
"prepare".


Sincerely,

Joshua D. Drake

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
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC
Postgresql support, programming, shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com



pgsql-general by date:

Previous
From: Dr NoName
Date:
Subject: postgresql locks the whole table!
Next
From: Alex Page
Date:
Subject: Re: C Programming with postgres.h - my function crashes