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

Re^4: SQL Database table to Perl Spreadsheet script

by dinkar (Initiate)
on Oct 14, 2012 at 09:01 UTC ( #998936=note: print w/ replies, xml ) Need Help??


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

I just get the heading in the output i.e., in the excel sheet also know as spreadsheet


Comment on Re^4: SQL Database table to Perl Spreadsheet script
Re^5: SQL Database table to Perl Spreadsheet script
by Anonymous Monk on Oct 14, 2012 at 09:24 UTC

    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 )

      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://998936]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (5)
As of 2014-10-02 11:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    What is your favourite meta-syntactic variable name?














    Results (55 votes), past polls