Re: DBI SQLite

Replies are listed 'Best First'.
Re^2: DBI SQLite by Anonymous Monk on Nov 11, 2011 at 02:00 UTC
Hi, This is very good advice. The versions of SQLite that you used to create the DB, and the one that Perl is using to access it must be at least a close match. I have had exactly the same problem as you are getting when they are not. J.C.	[reply]
Re^3: DBI SQLite by Anonymous Monk on Nov 11, 2011 at 02:04 UTC
In fact I now always use Perl to create the DB so that I know I won't get this problem. J.C.	[reply]
Re^2: DBI SQLite by mikasue (Friar) on Nov 10, 2011 at 22:42 UTC
Additional Information: I was using DBD::CSV at first and everything was working beautifully. I then got the bright idea to use SQLite. After the initial connection code, is there any difference in how to execute queries? Here is how I accessed db with CSV... `$vquery = "SELECT * FROM mytable WHERE myfield = 2"; $vsth = $dbh->prepare($vquery); $vsth->execute();` [download]	[reply] [d/l]