Sending the SQL - some tips

• Use "here doc" constructs!

• Use placeholders! (be $sth->prepare-d)

  • prepare once, execute many

• But don't $dbh->quote() me on that

  • Use $dbh->quote() for items interpolated into sql as perl strings
  • items put in placeholders don't need to be quoted