in reply to Re^3: SQL Database table to Perl Spreadsheet scriptin thread SQL Database table to Perl Spreadsheet script
Ok, so the problem is with the while loop, either
You can find out what the problem is by using print ( Basic debugging checklist )
It's actually worth while learning how to debug this yourself, as previously suggested.
Thanks but can you please please help me by doing the corrections in the code I gave. Please
No, that would require that I dummy up a database... OTOH what marto said
OTOH I feel if you've mastered cross posting :) you ought to be able to handle adding "print" to your program :)
OTOH if you add DBI->trace(1); you'll get debug output that shows if the query is a success and how many rows are returned
OTOH you can eliminate filtering you do in your program with a better SQL query, see Re^6: SQL Database Table to Perl Script, DBI recipes
DejaVu Sans Mono
Droid Sans Mono
Envy Code R
Source Code Pro
The default, whatever it is
Results (87 votes). Check out past polls.