Re: $dbh->unquote()

[Ian Harisay]

I think the problem is that when you get the info back out of the db it 
is for some reason coming as a string literal.  Meaning it isn't 
translating your \n.  Now if it is coming as a string literal you can 
simply:

 ## assume $var a holds your string.
 $a =~ s/\\n/\n/g;
 print $a;
This can be costly if the contents of $a is large.

Ian

Brian Spindler wrote:

The file prints out for example:

LINE1\n LINE2\n LINE3\n

So the '\n' is printed as if I went print '\n'; and what I want them to do
is print carriage returns.
Brian

-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 27, 2003 11:50 AM
To: Brian Spindler; [EMAIL PROTECTED]
Subject: RE: $dbh->unquote()

At 11:33 -0500 3/27/03, Brian Spindler wrote:
 

If printed in a windows environment "\n" is a carriage return.
Brian
   

You still haven't said what "as they should" means.  You say
that \n's don't print as they should, but not what actually happens.
Do they just disappear entirely?  Do they get turned into something
else?  What?
 

-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 11:32 AM
To: Brian Spindler; [EMAIL PROTECTED]
Subject: Re: $dbh->unquote()
At 11:19 -0500 3/27/03, Brian Spindler wrote:
   

Hi guys, gals!

	I have a pretty big string that I am inserting into MySQL via the
$dbh->quote($str) function, this works great however now when I pull the
data back out of the database and go to write it to a file the \n
     

characters
   

that were inserted by quote are not being written back out as carriage
returns as desired.  How can do a reverse of quote() or just get those
"\n"'s to print out as they should! =) ahh.. I'm frustrated, I tried
everything even split('\n',$str) and then reinserting the "\n".  Doesn't
work, please help!
Thanks in advance!
Brian
     

What do you mean by "as they should"?  After all, "\n" isn't a carriage
return.