Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^5: SQL Database table to Perl Spreadsheet script

by Anonymous Monk
on Oct 14, 2012 at 09:24 UTC ( #998942=note: print w/ replies, xml ) Need Help??


in reply to Re^4: SQL Database table to Perl Spreadsheet script
in thread SQL Database table to Perl Spreadsheet script

Ok, so the problem is with the while loop, either

  • the query returns zero rows
  • or you skip all the results
  • or write_row fails silently

You can find out what the problem is by using print ( Basic debugging checklist )


Comment on Re^5: SQL Database table to Perl Spreadsheet script
Re^6: SQL Database table to Perl Spreadsheet script
by dinkar (Initiate) on Oct 14, 2012 at 10:02 UTC
    Thanks but can you please please help me by doing the corrections in the code I gave. Please

      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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://998942]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (4)
As of 2014-08-23 09:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (173 votes), past polls