I have written an ASP.NET User Control that acts like a simple HTML form. It allows the user to fill in data into the different fields, then click Submit. The User Control processes the data and does several SQL statements to get the entry into the Database Structure as if you entered it from the CMSDesk. This all works fine unless you try to insert a field that exceeds the column's max length, obviously.

(This is done to circumvent the CMSDesk so that users can post a job listing without going through the CMSDesk itself. Then, an administrator logs on and approves the listing. This is done with a workflow and works correctly in all other cases.)

However, I changed the database table to allow a larger number of characters for a couple columns. Now my inserts work fine up to the new character limit. But, when I try to view the page through the CMSDesk I get an error saying that the field exceeds the character limit. This is confusing me because the database table says that it allows fields to be longer than the value in question.

Does the CMSDesk check the length of the field against some other value? (The table that I am accessing is not one of the default CMS tables; it is one that I have created.)


I realize that I am being a little vague. I can go into more depth if necessary, but perhaps there is a simple answer that I am just not seeing.