> From: Todd Nemanich [mailto:[EMAIL PROTECTED]]
> I'm having some trouble with the DBD::Pg driver. I'm > tring to insert a > record, and it tells me that I have a invalid placeholder. I'm not > trying to use a placeholder at all, so I'm a little confused > as to where > it came from. Here is the statement: .... > VALUES .... > 11\:16\:43', '2001-01-17 00\:00\:00', '2001-01-16', 'Phoned .... > > and I get this error: > Placeholder :0 invalid, placeholders must be >= 1 at > /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/Pg.pm line 118. This would probably be a good place to use placeholders. I don't know how Postgres quotes or escapes things that need to be quoted or escaped, but placeholders or the $dbh->quote() method would do it correctly for you. And placeholders, IMO, would be easier. HTH, Douglas Wilson
