I'm running on FREEBSD with MySQL database. Our platforms may be way different, but here's a chunk of code that works for me. My sth is written a little differently.

     my $sth = $dbh->prepare('SELECT * FROM applicants WHERE date_col 
+= ? ORDER BY date_col, job_position'); 
     $sth->execute($date) or die $sth->errstr; 

     while (my @result = $sth->fetchrow_array()) {
        print qq(@result\n);
        }
[download]

peppiv