Re: [MacPerl-AnyPerl] DBI under the MAC

On Dec 9, 2011, at 4:42 AM, Sean Murphy wrote:

> my $sth2 = $dbh->prepare("insert into trans (accounts, transaction_date, description, amount, amount_type, transaction_type, serial, category_id) values (?, ?, ?, ?, ?, ?, ?, ?);")
> 	          or die("Cannot prepare: " . DBI::errstr() );
> 
> 
> When the above is executed in the full script. We get the following error:
> 
> DBD::SQLite::db prepare failed: table trans has no column named accounts at ./insert_budget.pl line 60.
> Cannot prepare: table trans has no column named accounts at ./insert_budget.pl line 60.

"accounts" (plural)

> sqlite> .schema trans
> CREATE TABLE trans (transaction_id int primary key, account int, transaction_date date, description varchar(80), amount decimal (11,2), amount_type varchar(3) not null, transaction_type varchar(40), serial varchar(40), category_id int);

"account" (singular)

HTH,

Keary Suska

• DBI under the MAC by Sean Murphy
• Re: [MacPerl-AnyPerl] DBI under the MAC by Keary Suska
• Re: [MacPerl-AnyPerl] DBI under the MAC by Sean Murphy