in reply to set_sql, MySQL, Class::DBI and using a SQL LIMIT

This is a known bug in DBD::mysql and has nothing to do with Class::DBI. Check out this conversation for more info and a possible solution.

  • In general, if you think something isn't in Perl, try it out, because it usually is. :-)
  • "What is the sound of Perl? Is it not the sound of a wall that people have stopped banging their heads against?"
  • Comment on Re: set_sql, MySQL, Class::DBI and using a SQL LIMIT

Replies are listed 'Best First'.
Re^2: set_sql, MySQL, Class::DBI and using a SQL LIMIT
by steve_sims (Initiate) on May 04, 2005 at 16:04 UTC
    Thanks for the quick response. The discussion you pointed to was indeed very informative.

    What I ended up doing was dynamically creating my set_sql string, thus when I call my search_withlimit call I don't need to pass it any parameters, so they can't get filled in incorrectly.