in reply to (jeffa) Re: DBI SQL Query Question
in thread DBI SQL Query Question

Ha, I guess an error message would help, but I don't have one, if I run the SQL command by hand it returns the results I expected, but as soon as I put it in the .pl script...no luck! TA

Replies are listed 'Best First'.
Re(3): (jeffa) DBI SQL Query Question
by dmmiller2k (Chaplain) on Jan 12, 2002 at 00:23 UTC

    What data types are your Month and Day columns? Presumably int from your example, but you never know...

    Problems with prepared statements are notoriously difficult to simulate at the prompt, since command-line SQL utilities (isql, sqlplus, et al) don't support the concept.

      You assume right, the table is very simple and those two fields are both int.