in reply to DBI SQL problem

Check the data type of the 'date' column. Your SQL statement should work for the DATE type, but if you are storing the date as a string, the return will be alphabetized. You should have shown us the order you get.

Update: Aha! My bad, I should have noticed. 'date' is illegal as a column name because it's a datatype. Just pick another name.

After Compline,
Zaxo

Replies are listed 'Best First'.
Re: Re: DBI SQL problem
by glickjd (Novice) on Sep 22, 2002 at 19:42 UTC
    The data type for the date column is DATE. I can't show you the order the rows are returned because I'm at a different computer right now.

    I do believe however, the rows returned were in the same order as stored in the database. Is 'date' a valid column name? I really don't have any ideas what's wrong here. Thanks for the help.

[reply]

In Section Seekers of Perl Wisdom