>I actually had the datatype as text first, then changed to varchar(255) to
>try and troubleshoot. I did trim() and it worked. However, that was not
>the problem. It was actually interesting. I had some select boxes in the
>form immediately preceding the text box. Choosing something was not
>required. However, due to my sloppiness, one of the selects returned a 4
>character value by default. The underlying DB table could only accept 3
>characters.
>
>This is interesting because it did not throw an error that pointed to that
>field, which I should have noticed anyway. CF was pointing me to the
>textarea, rather than the select. Thanks for the tips though!
Remember, that you still might have to trim on the select. SQL server
sometimes puts in random trailing whitespaces. I generally insert without
a trim and select with a trim.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
