ASP Need Help.. I hv a page with around 140 fields dynamically generating from database. How to set MAXlength?

Question

on those text field..? Urgently required..

Answer 1

This could be a little tricky to do effeciently, but it's a great idea to ensure that people won't get error messages for entering too much data.

You can query the server to get metadata for a table, from which you can find the maxlength of a field. For example:

SELECT
CHARACTER_MAXIMUM_LENGTH

FROM
INFORMATION_SCHEMA.Columns

WHERE
TABLE_NAME = 'Employees'

This will return the length for all of the columns. You can loop through this recordset to dynamically set the max length of the fields.

Answer 2

In front end ie. in ASP, In HTML you can set on of the property of the text box called "MaxLength", given an equalto symbol and provide watever length you want.

Answer 3

Sally field became so attractive in all her video clips with Burt Reynolds and that Trans Am. loved those video clips. Jane Fonda is fairly no longer my sort of woman, regardless of she has an mind-blowing appearing potential. Sally field has continually been so 'ignorant,' 'sweet,' or 'the down living house woman' from what i have seen. metal Magnolias, Smoky and the Bandit, and Mrs. Doubtfire are a number of Sallie's perfect video clips i imagine i have seen.

Answer 4

if you are using basic HTML text form fields then add the maxlength attubute to the input tag