well, ive modified my code slightly, and this is the error that im getting now
Can't locate object method "execute" via package "DBI::db" (perhaps yo
+u forgot to load "DBI::db"?) at c:\foxserv\apache\cgi-bin\access2.pl
+line 12.
and heres what my code looks like
#!C:/Perl/bin/perl.exe
use CGI::Carp "fatalsToBrowser";
use CGI qw(:standard);
use DBI;
print header();
my $DSN = 'driver=Microsoft Access Driver (*.mdb);dbq=C:/FoxServ/Apach
+e/cgi-bin/test.mdb';
my $dbh = DBI->connect("dbi:ODBC:$DSN", '','')
or die "$DBI::errstr\n";
$dbh->execute();
@information = $dbh->fetchrow_array;
foreach $test (@information){
print $test;
print "\n<br>\n";
}
$dbh->disconnect;
$dbh->finish;
what do i do? |