I have a DBI script written to select from a .dbf file and need to refine
the select statement with an IN statement for a list of 2 digit numbers. I
tried the statement below and get a preparse error. Doesn't DBI have a IN
or List command? Can anyone shed some light?
use DBI;
$fdate="030217";
$ffdisps="01";
$flist=`cat /u/server/data/vrdctcbk.def | cut -d, -f1 | wc -l`;
chomp($flist);
$flist =~ s/ //g;
my $dbh = DBI->connect("DBI:XBase:/u/server/data/cbv/dbsls") or die
$DBI::errstr;
my $sth = $dbh->prepare("select * from $intab where o_curdate = ? and
o_fdisp in (?) ") or die $dbh->errstr();
$sth->execute("$fdate","$ffdisps") or die $sth->errstr();
Jeff Slutzky
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
