RE: DBI and SQLite efficiency

2009-01-13 Thread Southworth, Harry
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

DBI and SQLite efficiency

2009-01-13 Thread 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 create an XML report - one report for

MS Word question

2003-01-24 Thread Southworth, Harry
I'm running Perl on Cygwin on top of Windows 2000. I have a lot of ascii text files that someone has thoughfully saved as Microsoft Word documents. If I open them in a text editor, I can see the ascii text, but there is some junk at the top and bottom. Testing the files with -T tells me they're no