Ive encountered this at my last job and we were using perl as our backend.
Before inserting into the database, check for \n or \r and replace with
a combo of chars that are mostly likely not to be typed into the text field.
Examples: ][, or |43; or whatever...
Then when you reread back from the database and output the data, swap your
special newline chars with \n.
A bit of a pain, but it works.
Kevin Johnson
KJ
-----Original Message-----
From: Mat Marlow [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 8:42 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] TEXT fields without line breaks
Hi all,
(I'm not sure if this is the right place to submit this but I'm having
problems with the php.general group)
I am in desperate need for a solution to HTML text fields not storing new
lines. I'm storing news articles in a database but all the text just ends up
in a big block because it ignores line breaks. Is there a way around this
without having to upload text files?
Thanks,
Mat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
