Re: MySQL Truncated returns

2003-01-31 Thread Zak Greant
On Thu, Jan 30, 2003 at 11:40:06AM -0500, Anna Noel Leavitt wrote: Hello all- I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored in the column has a space in it (for example, Tampa Bay), it will only

RE: MySQL Truncated returns

2003-01-31 Thread Jennifer Goodie
] Subject: Re: MySQL Truncated returns Hello all- I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored in the column has a space in it (for example, Tampa Bay), it will only return Tampa (I have the length set

Re: MySQL Truncated returns

2003-01-31 Thread Steve Edberg
I'm 97.5% sure this will turn out to be a HTML form issue. You probably echo the field without quotes like this input type=text name=some_name value=Tampa Bay / instead of input type=text name=some_name value=Tampa Bay / -steve At 11:40 AM -0500 1/30/03, Anna Noel Leavitt wrote: Hello

Re: MySQL Truncated returns

2003-01-30 Thread Anna Noel Leavitt
Hello all- I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored in the column has a space in it (for example, Tampa Bay), it will only return Tampa (I have the length set at 30 so it is not a length issue). I