in reply to Re^2: DBI error Can't mix placeholder styles (:foo/?)
in thread DBI error Can't mix placeholder styles (:foo/?)

Yes, sorry. You need to bind the input parameters by calling bind_param().

  • Comment on Re^3: DBI error Can't mix placeholder styles (:foo/?)

Replies are listed 'Best First'.
Re^4: DBI error Can't mix placeholder styles (:foo/?)
by Anonymous Monk on Jun 21, 2011 at 10:00 UTC
    Thank you. Must I bind each indicidually, e.g.
    $sth->bind_param(1, $foo); $sth->bind_param(2, $bar); ....

      If you are mixing input and output parameters I believe so.