Re: DBI Bind Columns

Not sure about the bind variables, but the first bit should look like this:

$query = <<'END';
select date, run_time, run_dis, num_push,
       num_sit, abs, comment, workout_id, scored
from "cshaws_Schema"."log2"
where pid = ? order by date
END

$sth = $dbh->prepare($query);
$sth->execute($pid);
[download]

_______________
DamnDirtyApe

Those who know that they are profound strive for clarity. Those who
would like to seem profound to the crowd strive for obscurity.
            --Friedrich Nietzsche

In Section Seekers of Perl Wisdom