Hi, The following does not return a correct result set, do you have any
idea? the back end is MSAcess97, I use dbd-odbc 1.13.(ActivePerl 5.8.8.817)
I appreciate your help
very
much.
$sql = "select refno, slsmn, ordDate, function,workno from wkmaster where
ordDate between #$sdate# and #$edate# order by slsmn";
$dbh = DBI->connect($dsn,$user,$pswrd,$driver,{RaiseError=>1}) or die
"Database connection not made: $DBI::errstr";
$sth = $dbh->prepare($sql);
$sth->execute();
my @rs = $sth->fetchrow()
Thanks,
Sam
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
