in reply to Re: Now to do simple select with Net::MySQL
in thread How to do simple select with Net::MySQL

Interpolating variables in a SQL query is a NO-NO.

Use placeholders. Don't give bad advice.

  • Comment on Re^2: Now to do simple select with Net::MySQL

Replies are listed 'Best First'.
Re^3: Now to do simple select with Net::MySQL
by hmerrill (Friar) on Sep 15, 2004 at 11:44 UTC
    I've never before heard that interpolating variables in SQL is bad advice - why is that bad advice??

    It's true that using placeholders is desirable for a number of reasons, but interpolating variables in SQL is not *bad*.