http://qs1969.pair.com?node_id=306745


in reply to Re: What are placeholders in DBI, and why would I want to use them?
in thread What are placeholders in DBI, and why would I want to use them?

You mean that DBI queries should be written: 
my $query = $dbh->prepare
    ( "select id, name from user where name = ?" );
$query->execute( $name_from_params );

[download]
Instead of: 
my $query = $dbh->prepare
    ( "select id, name from user " .
      "where name = '$name_from_params'" );
$query->execute();

[download]
Couldn't agree more.

--tidiness is the memory loss of environmental mnemonics

In Section Seekers of Perl Wisdom