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