my $statement = "SELECT id
FROM comments
WHERE comment_date BETWEEN '01-JUL-02' AND '01-DEC-2002";
[download]

This sql returns all id's from table "comments", regardless of what comment_date is...