Re: Converting carriage returns to HTML breaks

[chromatic]

in reply to Converting carriage returns to HTML breaks

Are you certain they're carriage returns? That's \r, not \n.

You might need to post some example input and output otherwise.

[htmanning]

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.

[Anonymous Monk]

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

[fullermd]

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.