Re^2: 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.
[download]

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.

Comment on Re^2: Converting carriage returns to HTML breaks Download Code

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	[reply]
Re^3: Converting carriage returns to HTML breaks by fullermd (Vicar) 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.	[reply]