in reply to Quoted dates in SQL with placeholders

'date' remains an illegal column name.

The placeholder mechanism provides the quotes. You probably should not have a placeholder after the order clause. In what format do you provide the dates? They should be 'yyyy-mm-dd' formatted strings. &POSIX::strftime can provide those if you are starting from a localtime generated timestruct array.

After Compline,
Zaxo

Replies are listed 'Best First'.
Re: Re: This one is perl related
by glickjd (Novice) on Sep 22, 2002 at 21:49 UTC
    Thanks for the help. When I read your last posting, I missed the part about the date column being invalid. You probably wondered why I asked if date was valid right after that.

    I changed the name of this column to mileage_date and it seems to be running now. Thanks a lot Zaxo. I really appreciate it.

    Jeremy

[reply]

In Section Seekers of Perl Wisdom