Bart Kersteter [mailto:[EMAIL PROTECTED] wrote:
> I am using this statement to try and insert the data:
> *-----------------------------------
>
> my ($userid, $year, $week, $cpu, $io);
>
> $source_sth->bind_columns(\$userid, \$year, \$week, \$cpu, \$io);
>
> my $insert_sql = qq{ insert into user_history_stats (database, server,
> year, week, username, cpu, io)
> values ('$orasid', '$server', ?, ?, ?, ?, ?)
> };
>
> my $target_sth = $target_dbh->prepare( $insert_sql ) or die "Can't
> prepare insert statement: " . $target_dbh->errstr;;
Is this your actual code? You're calling bind_columns() on $source_sth,
then preparing $target_sth. Where do you bind the values to $target_sth?
What is $source_sth?
Why aren't you using placeholders for database and server?
Ronald
