Re: DBD::Pg problem

From: Alex Satrapa <alex(at)lintelsys(dot)com(dot)au>
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 09:31:04
Message-ID: 3FCDAD58.6060905@lintelsys.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvar Freude 2003-12-03 09:36:59 Re: Cast text to bytea
Previous Message Richard Huxton 2003-12-03 09:03:30 Re: Transaction Question