in reply to Re: Converting Special Characters
in thread Converting Special Characters

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re: Re: Re: Converting Special Characters
by dws (Chancellor) on Oct 08, 2002 at 02:58 UTC
    No No No, when I insert it in, everthing after the quotes is deleted!

    Have you verified that? When last we left this issue, I'd recommended that you manually inspect the database, rather than waiting until you'd generated HTML from it. Did you? Was data truncated in the database?

    Update: andrew confirmed by /msg that the data in the database was O.K.

[reply]
Re: Re: Re: Converting Special Characters
by nagilum (Initiate) on Oct 08, 2002 at 09:17 UTC
    When inserting data into a db you should use $dbh->quote($var) for correct quoting.
[reply]
      When inserting data into a db you should use $dbh->quote($var) for correct quoting.
      Not when using placeholders, as he does now.
[reply]

In Section Seekers of Perl Wisdom