Re: perl DBI:OCDB execute failed. Too few parameters.

2012-06-21 Thread Yu-Shan Wang
Hi. I found the problem! (Took me an hour. > _<) Instead of *my $condition = ' FIELD1=A '; *I should write *my $condition = " FIELD1= ' A ' "; * Thanks, Tiffany

perl DBI:OCDB execute failed. Too few parameters.

2012-06-21 Thread Yu-Shan Wang
Hi, I need help with Perl DBI. I try to fetch the table from Microsoft access database. I want to return the whole table under the condition "FIELD1=A". The following is my code. my $db= "C:\\Users\\yushanwa\\Desktop\\DATABASE.accdb"; my $DSN = "DRIVER={Microsoft Access Driver (*.