in reply to Re: Converting carriage returns to HTML breaks
in thread Converting carriage returns to HTML breaks

Well, maybe I'm not certain. I hit the Return key in the email form. In all the other scripts I've used /n and it worked fine. I've tried /n and /r and neither work. I'm stumped. Here's what I'm doing.
Message field as it appears in database: This is a test message. This is line 2 of test message. #This is how I'm getting it from the database... $SQL="SELECT * FROM table WHERE name = '$name'"; &Do_SQL; $pointer = $sth->fetchrow_hashref; $message = $pointer->{'message'}; $message =~ s/\n/\<br\>/g; Output: This is a test message. This is line 2 of test message. If I View Source it shows: This is a test message. This is line 2 of test message.
I'm wondering if I have to do something special before it gets stuffed in the database, but I don't think so. I'm doing it the same way I always have.

Replies are listed 'Best First'.
Re^3: Converting carriage returns to HTML breaks
by Anonymous Monk on Apr 16, 2012 at 01:58 UTC

    I'm afraid that won't work

    Use Data::Dumper or Data::Dump to Dump data from your program as perl structures, and then show us that

Re^3: Converting carriage returns to HTML breaks
by fullermd (Priest) on Apr 17, 2012 at 00:46 UTC

    I'm wondering if I have to do something special before it gets stuffed in the database, but I don't think so.

    As a general rule, you do not want to do something special before the database. You want to do something special before the email. When you need a particular encoding or alteration of your data for one use, you'll find yourself having to backtrack less often by doing that transformation as late and as local as possible.