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
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 create an XML
report - one report for
