Tried that ...it is definetely the to_email field, not any others that is causing the problem.
Jason -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alex Satrapa Sent: Wednesday, December 03, 2003 6:31 PM To: Ausrack Webmaster Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] DBD::Pg problem 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
