P is for Practical | |
PerlMonks |
SQL INSERTs don't workby ido50 (Scribe) |
on Nov 08, 2004 at 13:29 UTC ( [id://406040]=perlquestion: print w/replies, xml ) | Need Help?? |
ido50 has asked for the wisdom of the Perl Monks concerning the following question:
Hi there! I've been trying to use DBI with DBD::SQLite to handle some databases in a program I'm writing. I have created a little 'setup script' that creates appropriate tables and inserts some initial entries. The tables are created with no problems. When performing simple INSERTs, no errors are raised, but dumping the results of a simple "SELECT * FROM table_name" gives nothing, actually stopping the program (That's how it seems). For example, let's say I'm doing this (Using an example from CPAN): The output here will utterly be nothing. The only thing that will be printed is the output from $q->start_html. No output is given from $q->end_html. Executing this script again will die complainning that the 'user' table already exists. Any thoughts? Ido. ------------------------- Live fat, die young
Back to
Seekers of Perl Wisdom
|
|