Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^2: Converting carriage returns to HTML breaks

by htmanning (Scribe)
on Apr 16, 2012 at 00:51 UTC ( #965215=note: print w/ replies, xml ) Need Help??


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.


Comment on Re^2: Converting carriage returns to HTML breaks
Download Code
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 (Curate) 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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://965215]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (7)
As of 2014-07-10 10:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (206 votes), past polls