in reply to $sth->execute error

execute argument is bind value not the sql statement itself, after prepare just execute the sql and get the results from fetchall_arrarref (eg).
see man DBI for more information

Vivek
-- In accordance with the prarabdha of each, the One whose function it is to ordain makes each to act. What will not happen will never happen, whatever effort one may put forth. And what will happen will not fail to happen, however much one may seek to prevent it. This is certain. The part of wisdom therefore is to stay quiet.

Replies are listed 'Best First'.
Re^2: $sth->execute error
by RobertCraven (Sexton) on Feb 14, 2009 at 06:29 UTC
    Thanks for the explanation!