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

From Alex Satrapa
Subject Re: DBD::Pg problem
Date
Msg-id 3FCDAD58.6060905@lintelsys.com.au
Whole thread Raw
In response to Re: DBD::Pg problem  ("Ausrack Webmaster" <webmaster@ausrack.com.au>)
Responses Re: DBD::Pg problem
List pgsql-general
Ausrack Webmaster wrote:
> The thing is...I am not. I am inserting it into a varchar field.

Are there any single quotes in the message body?  They will wreak havoc
with the rest of the query. And why are you putting single quotes around
'$parent'?

What happens if you move the '$body' to the end:

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

Alex


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Transaction Question
Next
From: Alvar Freude
Date:
Subject: Re: Cast text to bytea