Re: DBD::Pg problem

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Ausrack Webmaster <webmaster(at)ausrack(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: DBD::Pg problem
Date: 2003-12-03 16:48:49
Message-ID: 3FCE13F1.8060307@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)somedomain(dot)com>": can't parse "<support(at)somedomain(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Page 2003-12-03 16:57:59 Re: C Programming with postgres.h - my function crashes
Previous Message Dr NoName 2003-12-03 16:44:17 postgresql locks the whole table!