Re: [PHP-DB] php maximum characters in text field

2007-10-15 Thread OKi98
VanBuskirk, Patricia napsal(a): The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread Instruct ICC
varchar maxs out at 255 characters just for clarification, mysql varchar easily can hold more than 255 characters (I remember it was the case in ancient 3.x times) only if one wants to store newlines he must use type text just my 2 cent News to me, so I check the docs.

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread VanBuskirk, Patricia
I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will clean up input,

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread Instruct ICC
I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will clean up input,

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread VanBuskirk, Patricia
It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get made in the d'base... the confirmation email went out, but wherever info was supposed to kick back from the d'base (ie. Order number), it showed an undefined variable error. -Original Message- From: Instruct

Re: [PHP-DB] php maximum characters in text field

2007-10-15 Thread OKi98
VanBuskirk, Patricia napsal(a): It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get made in the d'base... the confirmation email went out, but wherever info was supposed to kick back from the d'base (ie. Order number), it showed an undefined variable error.

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread Instruct ICC
Do you see those apostrophes in that text? They need to be properly escaped. Date: Mon, 15 Oct 2007 15:09:52 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Here is the exact text he