Re: Inserting a record into an Access database

my $sql ="INSERT INTO Billing VALUES ('Doyle','doyle.com','1010','100'
+,'Yes')";
[download]

Don't do this! Maybe it's not the problem just in this case, but it's dangerous anyway. What if someone, a year later changes the schema of the database. Slightly, just by adding a column into this table, booooooooom.

Always specify the columns you intend to insert to. Please!

Jenda
We'd like to help you learn to help yourself
Look around you, all you see are sympathetic eyes
Stroll around the grounds until you feel at home
-- P. Simon in Mrs. Robinson

Comment on Re: Inserting a record into an Access database Download Code

Replies are listed 'Best First'.
Re^2: Inserting a record into an Access database by RiotTown (Scribe) on Feb 22, 2005 at 03:53 UTC
Without a specific error message (call ->errstr() in your die statement), I'd have to blindly say that Jenda is onto your problem. Are you sure that you are inserting the correct number of values into the table and that you are inserting the correct type of values into the table?	[reply]