[Templates] [OT] mySQL Quotes

[Nick Tonkin]

On Fri, 20 Sep 2002, Wassim M. wrote:

>     Also, I have another question that's probably not related, please don't
> respond if you feel I should be outta here. I keep an online journal for my
> family and friends, the site uses template toolkit and a mysql database for
> everything, I'm having a problem inserting quotes into the mySQL database.
> When I post content I use an editor from sourceforge and part of the post
> includes "'s that are in html. As soon as the variable is put into the
> insert statement the first quote ends the statement and it gives me a mySQL
> error. I have found a dumb workaround but it doesn't work 100% I change all
> quotes to &quote; equiveleant and change it back when I need to edit and
> post. Now, the Gossamear Threads mysqladmin utility can post quotes just
> fine, so, I know there has to be a way. I was told to use placeholders, but,
> I don't really understand how:

perldoc DBI

this will lead you to enlightenment about placeholders. Just read it
carefully, as many times as necessary to understand it. It'll take more
than once.

- nick