Carriage Returns

am 06.11.2009 17:24:00 von Dan Shirah

--0016e644cd9681110c0477b64539
Content-Type: text/plain; charset=ISO-8859-1

Hello all,

Basically I have a form with a . 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 --0016e644cd9681110c0477b64539-- </article> <article> <h2>Re: Carriage Returns</h2>am 06.11.2009 18:16:05 von joao Are you using nl2br to convert before recording or after? "Dan Shirah" <mrsquash2@gmail.com> escreveu na mensagem news:a16da1ff0911060824k779f7457wa1111fd6e8f4e419@mail.gmail .com... > 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 </article> <article> <h2>Re: Carriage Returns</h2>am 06.11.2009 20:28:04 von List Manager 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 </article> <article> <h2>Re: Carriage Returns</h2>am 06.11.2009 21:29:52 von Dan Shirah --0016e6475b20cb4d8b0477b9b433 Content-Type: text/plain; charset=ISO-8859-1 > > 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. > > > I'm getting the generic error message: Prepare fails (E [SQLSTATE=IX 000 SQLCODE=-282]) My insert statement when echo'd out using print_r($insert) is nothing complex. INSERT INTO my_table VALUES (0, 'This is my text. When I use carriage returns it breaks. I am not sure why.') --0016e6475b20cb4d8b0477b9b433-- </article> <article> <h2>Re: Carriage Returns</h2>am 08.11.2009 17:40:55 von John Hicks 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 João Cândido de Souza Neto wrote: > Are you using nl2br to convert before recording or after? > > This is probably an Informix problem or a problem with your interface to Informix. (I say that because I store textarea data with embedded newlines all the time in MySQL using the PHP mysql_ functions.) What interface are you using? ODBC? What errors do you get from Informix when it bombs? I'm guessing an embedded CR or LF character is breaking something as it's being passed to Informix. As João implies, if you really are changing these to break tags, you shouldn't have a problem. So you might try outputting the results of your conversion to your PHP error log before you pass it to Informix. You may find more help on an Informix list. John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php </article> <article> <h2>Re: Carriage Returns</h2>am 08.11.2009 17:44:34 von Eddie Drapkin On Sun, Nov 8, 2009 at 11:40 AM, John List <johnlist@gulfbridge.net> wrote: > Dan Shirah wrote: >> >> Hello all, >> >> Basically I have a form with a <textarea>. Â The user can enter up t= o 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 conve= rt >> the carriage returns, but it still crashes. >> >> I'm using an informix database and the column is: my_text Â Â C= HAR(5000) >> >> Any ideas why it crashes any time there is a carriage return in the text >> area? >> >> Thanks, >> Dan > > JoÃ£o CÃ¢ndido de Souza Neto wrote: >> >> Are you using nl2br to convert before recording or after? >> >> > > This is probably an Informix problem or a problem with your interface to > Informix. (I say that because I store textarea data with embedded newline= s > all the time in MySQL using the PHP mysql_ functions.) > > What interface are you using? ODBC? > > What errors do you get from Informix when it bombs? > > I'm guessing an embedded CR or LF character is breaking something as it's > being passed to Informix. As JoÃ£o implies, if you really are changin= g these > to break tags, you shouldn't have a problem. So you might try outputting = the > results of your conversion to your PHP error log before you pass it to > Informix. > > You may find more help on an Informix list. > > John > > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > It's probably worthwhile to note that nl2br does NOT replace \n and/or \r with but rather puts a before the newline character(s). Try str_replace("\r", '', $post_field). -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php </article> <article> <h2>Re: Carriage Returns</h2>am 08.11.2009 18:43:00 von Nathan Rixham Dan Shirah wrote: >> 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. >> >> >> > > I'm getting the generic error message: Prepare fails (E [SQLSTATE=IX 000 > SQLCODE=-282]) > > My insert statement when echo'd out using print_r($insert) is nothing > complex. > > INSERT INTO my_table VALUES (0, 'This is my text. When I use carriage > returns it breaks. I am not sure why.') > informix doesn't allow new lines in sql strings; unless you enable the "ALLOW_NEWLINE" setting on the server. to remove newlines I'd suggest stripping all vertical space and replacing it with spaces, then stripping down the excess horizontal space.. something like function strip_newlines( $string ) { $string = preg_replace( '/\v/' , ' ' , $string ); $string = preg_replace( '/\h\h+/' , ' ' , $string ); return $string; } $sql = strip_newlines( $sql ); regards, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php </article> <footer> <a href="/">Index</a> | <a href="/impressum.php">Impressum</a> | <a href="/datenschutz.php">Datenschutz</a> | <a href="https://www.xodox.de/">XODOX</a> </footer> </main> </body> </html>