Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re^2: create SQLite database problems

by chilledham (Friar)
on Mar 06, 2012 at 23:40 UTC ( [id://958185]=note: print w/replies, xml ) Need Help??


in reply to Re: create SQLite database problems
in thread create SQLite database problems

Just a minor point: Autocommit should be AutoCommit

Good suggestion! Still worked in my environment (and setting AutoCommit => 0 then doing $dbh->rollback(); did indeed create an empty SQLite database).

EDIT
Also, DBI expects AutoCommit & RaiseError to be passed in a hash reference:

$dbh = DBI->connect( $dsn, $username, $password, { AutoCommit => 1, RaiseError => 1} );

Replies are listed 'Best First'.
Re^3: create SQLite database problems
by Riales (Hermit) on Mar 07, 2012 at 18:30 UTC

    Blah, that'll teach me to forgo checking documentation and rely on my memory for such things. Good catch!

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (3)
As of 2024-04-23 23:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found