Mind you Pearl programmers, what would that do? On 3/20/06, Giff Hammar <ghammar@xxxxxxxxxxxxxxxxxx> wrote: > Thanks, Jeremy and Bastien. I just tried nl2br and it has the unfortunate > side effect of losing everything except the most recently added data when I > update the database. I think I need something like the 'local $/ = "\r\n"' > construct in perl... > > Giff > > _____ > > From: Jeremy Peterson [mailto:jeremy.peterson@xxxxxxxxx] > Sent: Monday, March 20, 2006 5:14 PM > To: Giff Hammar > Subject: Re: Remove newlines from field > > > Try nl2br. > > http://php.net/nl2br > > At 04:00 PM 3/20/2006, you wrote: > > > I am using a PHP script to pull information from a FoxPro database via ODBC. > One of the fields is a memo field (large text) that contains newline > characters. Displaying this info to the web page is fine as the newlines are > ignored. The challenge is when I combine user entered text with the existing > info and try to update the database. It fails with an "unrecognized command" > because the end of field delimiter is on a different line. We're running on > PHP 4.2.7 and I have tried using various combinations of str_replace to > eliminate the newline characters, but I have been unsuccessful. Any > suggestions? > > Giff > > Giff Hammar > IT Director > Certified Parts Warehouse > http://www.certifiedparts.com <http://www.certifiedparts.com/> < > <http://www.certifiedparts.com/> http://www.certifiedparts.com/> > mailto: ghammar@xxxxxxxxxxxxxxxxxx > V: 603.516.1707 > F: 603.516.1702 > M: 603.490.7163 > > > > > Jeremy Peterson, MACS > Automation Systems Administrator > Crowell Library > Moody Bible Institute > 820 N. LaSalle Drive > Chicago, IL, 60610 > > Email: jpeterso@xxxxxxxxx > Phone: 312.329.8081 > Fax: 312.329.8959 > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
