Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Quick DBI Fail Question

by jZed (Prior)
on Nov 07, 2007 at 23:40 UTC ( #649595=note: print w/ replies, xml ) Need Help??


in reply to Quick DBI Fail Question

> my $emps = $dbh->fetch_rowarray( "Insert into...." );
There are at least five major errors in that short snippet. Use $dbh->do("INSERT INTO ...");

The best way to get DBI to produce errors is to set $dbh->{RaiseError} = 1 in your connection. Then any errors will cause your program to die with error messages. If you want to see the messages in a browser, you'll need to use something along the lines of Carp qw(fatalsToBrowser).

update The errors: 1) The method name is fetchrow_array, not fetch_rowarray 2) It is a statement handle method, not a database handle method 3) It is for fetching data from SELECT statements, not for INSERT 4) it doesn't accept SQL as a parameter. 5) It returns an array (go figure), not a scalar.


Comment on Re: Quick DBI Fail Question

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (14)
As of 2015-07-02 19:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (44 votes), past polls