in reply to DBD::ODBC, Access, date comparisons

OK - I can do it with either
{d 'YYYY-mm-dd'} or #mm/dd/YYYY#
directly in the SQL statement. But, if I use placeholders, it craps out on me. The variables I'm using in the $sth->execute() command look correct if I print them out.

So, I'm a little stumped.

UPDATE

http://aspn.activestate.com/ASPN/Mail/Message/1438444

bind_param - looks like it could be my ticket.

I'm going to finally go eat some lunch now. I always let stuff slip when I'm stumped like this. Then, I'm starving, desperate, and in a bad mood. Typically, a user will now come up to me, and ask me to do a file restore from tape, because someone deleted something that SHOULD NOT have been in the public directory in the first place.

When I get back, I'll try the bind_param and see if I get any luck. In the meantime, if someone has any comments or encouragement, it would be great to see when I get back with a higher blood-sugar level.

Replies are listed 'Best First'.
Re: Re: DBD::ODBC, Access, date comparisons
by Anonymous Monk on Aug 08, 2003 at 08:18 UTC
    Did you ever get it to work? I have the same problem but I haven't tried bind_param.