more useful options | |
PerlMonks |
Re: Working with DBI and DBD::SQLite2by JamesNC (Chaplain) |
on Oct 30, 2004 at 15:01 UTC ( [id://404033]=note: print w/replies, xml ) | Need Help?? |
1. $dbh is undefined, I think you need to either change $D to $dbh or vice versa. 2. $s is undefined, I think you mean $sth Here is your stuff working and some modifications I made to show you some oddities ( that SQLite docs claim are not bugs but features...) about SQLite that I noticed right away. I don't like this rdbms because it really doesn't care what stuff you feed it. I defined an integer, but it doesn't complain when I send it something else. And you don't get an exception raised when you try to create a table with a bogus data type, which makes debuging difficult. I would also note that attributes like NULL and NOT NULL which are required when creating tables in most all rdbms's is ignored by SQLite. Also, a DATE datatype which would benefit from right away is absent in SQLite ( you should convert all your dates to a linear value if you want to use this tool and compare inside of SQLite? ) I personally don't think I will ever use this tool. There are too many free fully featured rdbms's out there. JamesNC
In Section
Seekers of Perl Wisdom
|
|