Hi Keary
Ouch, it was right in front of my nose and I didn't see it.
Thanks.
On 10/12/2011, at 2:53 AM, Keary Suska wrote:
> 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
|