Southworth, Harry wrote:
> I have a database with several tables in it, and each table contains data on
> lots of people. From one run of my program to the next, the tables could
> change, so my code needs to be fairly general.
>
> I want to pull the data for each person from each table, and cre
From: "Southworth, Harry"
> I think that if I append (rather than overwrite) each report with each
> table, I could restructure the code like you suggest. Thanks for
> pointing that out - it hadn't occurred to me.
>
> > my %sth;
> > for (0..$#tables){
> > $sth{$tables[$_]} = $dbh->prepare(
> >
Thanks.
I think that if I append (rather than overwrite) each report with each table, I
could restructure the code like you suggest. Thanks for pointing that out - it
hadn't occurred to me.
> my %sth;
> for (0..$#tables){
> $sth{$tables[$_]} = $dbh->prepare(
>"SELECT * FROM $theTable WHER
From: "Southworth, Harry"
> I have a database with several tables in it, and each table contains
> data on lots of people. From one run of my program to the next, the
> tables could change, so my code needs to be fairly general.
>
> I want to pull the data for each person from each table, and cr