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 i

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. http://

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, possi

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 I

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

2007-10-15 Thread Bastien Koert
Could it be an '&' ampersand in the data? Bastien> Date: Mon, 15 Oct 2007 13:29:02 -0400> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]; php-db@lists.php.net> Subject: RE: [PHP-DB] php maximum characters in text field> > It isn't sending to MySql, we use FileMaker Pro 9. A new record did not

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. -Origi

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

2007-10-15 Thread VanBuskirk, Patricia
Here is the exact text he submitted: Please initiate phone lines in the following locations in the Leon County Civic Center to support our home Men's and Women's Basketball games. Meeting room B: activate 4 lines on the North Wall and 4 lines on the South Wall - all lines should have long distance

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