Just curious. If you have a text box, have you considered changing the field type to text?
On Fri, Sep 11, 2009 at 6:34 AM, Stephane Vantroyen <[email protected]> wrote: > > Hi, > > to do you can use javascript, like here : > > http://javascript.internet.com/forms/limit-textarea.html > > Regards, > > Stephane > >> Hi >> Ive a text box on my form, and in the database it is set to allow 500 >> characters to be entered, however i can write any amount of characters >> above 500, I do get an error sayng: Error Executing Database Query. >> [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data >> would be truncated. >> >> But the email still sends anyway, what im trying to do is get rid of >> the error message altogether, so is there a way I can stop the cursor >> from typing past 500 characters? >> >> Thanks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326223 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
