Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^3: Perl DBI: problems inserting data to a table

by boftx (Deacon)
on Nov 21, 2013 at 13:10 UTC ( #1063733=note: print w/replies, xml ) Need Help??


in reply to Re^2: Perl DBI: problems inserting data to a table
in thread Perl DBI: problems inserting data to a table

Try using just what I wrote before:

print $sth->errstr unless $sth->execute(@arguments) > 0;

What you posted above doesn't capture the actual return value of the 'execute' call. You might need to say "$dbh->errstr" instead of "$sth->errstr".

It helps to remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.

Replies are listed 'Best First'.
Re^4: Perl DBI: problems inserting data to a table
by homeveg (Novice) on Nov 21, 2013 at 13:15 UTC
    I tried initially your string with the same result...

      It was my thought that maybe the data in one of the columns exceeded the DB field width, but if that is the case, you are not getting an error message that would show it. At this point I would start losing some hair.

      It helps to remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.
        Thanks once more! As I pointed already in the update of my question it seems problem was with the Storable driver itself. When I changed it to SQLite everything starts working fine.

        Although, I still don't get why it was not working without throwing any kind of exceptions or warnings...

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1063733]
help
Chatterbox?
[1nickt]: my $x = $aohoaoh->[0]->{' foo'}->[0]->{'bar' }; should work
[thepkd]: not indexing
[thepkd]: getting data out of the ds
[choroba]: it depends. Give more details, please
[thepkd]: i used a series of {}'s but it dont work
[choroba]: You need square brackets for arrays
[GotToBTru]: you can certainly construct a single expression to access any part of the data structure, without using temp variables. but you might make it easier on yourself and any other poor soul who has to understand your code if you do
[thepkd]: to dereference i mean
LanX .oO( oh tempz, oh moretz)
[thepkd]: @GotToBTru Sure. But.

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (14)
As of 2016-12-06 13:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (104 votes). Check out past polls.