I have a simple query using a LIKE in the statement and I just can get it to
return any data. I know it works because i can do it in sqlplus and get data
returned. I have tried everything to try to quote it correctly, like qq, qw,
dbh->quote and finally placeholders. Code is below, any ideas ?

Thanks 
Jim
------

# my $string = $dbh->quote("%7-Aug%");
my $date = qq(7-Aug);

my $sth = $dbh->prepare("SELECT * FROM uptime WHERE sdate LIKE ?" )
    or die "can't prepare: $DBI::errstr\n";

$sth->execute("%$date%") or die "can't execute $DBI::errstr\n";
my @row;
while (@row = $sth->fetchrow_array() ) {
        print "@row\n";
}


Reply via email to