Use maxlength=500 for the input field Agha
On Sep 11, 2009, at 6:28 AM, Damo Drumm <[email protected]> wrote: > > Hi > Iâve a text box on my form, and in the database it is set to allow 5 > 00 characters to be entered, however i can write any amount of chara > cters above 500, I do get an error sayng: Error Executing Database Q > uery. > [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:326220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

