in reply to SQL INSERTs don't work

Having added the "use DBI" and "use CGI" lines and given a value to $dbfile it all seems to work here when I test it from the command line. Which makes me think that it might well be a file permissions problem. Does the user that you are running the program as have permissions to create the SQLite file?

--
<http://www.dave.org.uk>

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg

Replies are listed 'Best First'.
Re^2: SQL INSERTs don't work
by tinita (Parson) on Nov 08, 2004 at 14:26 UTC
    Does the user that you are running the program as have permissions to create the SQLite file?
    note: permissions to write to the directory where the database file is, are also needed with SQLite. maybe the sqlite file is already there with the right permissions but directory permissions aren't there so that inserts fail...
[reply]

In Section Seekers of Perl Wisdom