in reply to My DBI suddenly can't handle placeholders in a LIMIT clause.

Just to get "closure" in the non-programming sense: Dreamhost eventually wrote back to me to say, yes, they had upgraded the version of the mysql driver. Not only that but they'd upgraded, found that lots of stuff fell over, so they downgraded again, but to a different version than the original one.

I don't know if I dare put my placeholders back or not!



Nobody says perl looks like line-noise any more
kids today don't know what line-noise IS ...
  • Comment on Re: My DBI suddenly can't handle placeholders in a LIMIT clause.

Replies are listed 'Best First'.
Re^2: My DBI suddenly can't handle placeholders in a LIMIT clause.
by Cap'n Steve (Friar) on Aug 27, 2007 at 07:16 UTC
    That reminds me, I actually did find (but can't find again) a mailing list discussion where they mentioned that using placeholders as part of the LIMIT was bad practice (although I have no idea why, or how that applies to DBI interpreting them as strings). For now, I'm just using the bind_param() workaround mentioned earlier because it's just prettier than building the query without placeholders.