Re: Carriage Returns

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



My guess is that you are getting an SQL error returned to you.  What does that
say?  Is it talking about a broken SQL statement?

Also, an example of the actual insert statement with example data would be helpful.

Dan Shirah wrote:
> Hello all,
> 
> Basically I have a form with a <textarea>.  The user can enter up to 5,000
> characters in this text area.
> 
> If the user just types text like: This is a test.
> 
> And saves it, there's no problem.
> 
> However if the user types:
> 
> This
> 
> Is
> 
> A
> 
> Test
> 
> And saves it, the insert bombs.
> 
> I've tried using nl2br($text) and str_replace("\r","#CR",$text) to convert
> the carriage returns, but it still crashes.
> 
> I'm using an informix database and the column is: my_text    CHAR(5000)
> 
> Any ideas why it crashes any time there is a carriage return in the text
> area?
> 
> Thanks,
> Dan
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux