Re: DBI placeholders

>>>>> "Evan" == Evan Zane Macosko <macosko(at)fas(dot)harvard(dot)edu> writes:

Evan> Hi everyone, I'm wondering if someone could explain to me
Evan> how placeholders work with Perl DBI linking to Postgresql.
Evan> I seem to have trouble using them in a loop. For example,
Evan> the code:

Evan> my $i = 0; $sth = $dbh->prepare("UPDATE yeast1 set ? = '?'
Evan> where yeast1.orf = temp.orf"); while ($i<$#columns) {
Evan> $sth->execute($i, $tables[$i-1]; $i++; }

Evan> This returns an error from the Pg parser. Any suggestions?
Evan> Also, this query is incredibly slow--does anyone have
Evan> suggestions for optimization?

Placeholders are for values not for column names, and you shouldn't
have quotes around the ? either.

Sincerely,

Adrian Phillips

--
Your mouse has moved.
Windows NT must be restarted for the change to take effect.
Reboot now? [OK]