in reply to On Handling Text (Blob) Column Types in MySQL/CGI

The simple routine to 'safe' the text wrt quotes etc. is $dbh->quote($text)

Cheers,
Ben.
update doh doh doh dohhhh....I knew that...that'll teach me to not skip the code and just read the description<g> - thanks hb

Replies are listed 'Best First'.
Re: Re: On Handling Text (Blob) Column Types in MySQL/CGI
by hardburn (Abbot) on Apr 04, 2003 at 14:56 UTC

    Using placeholders does that for you automagically.

    ----
    I wanted to explore how Perl's closures can be manipulated, and ended up creating an object system by accident.
    -- Schemer

    Note: All code is untested, unless otherwise stated