Hi SC

(Using DNN 6 and SC 4.99).

In this thread, I suggested that special instructions should be presented before payment (step 1). The solution given to me was to use Custom Textbox #1 instead of special instructions. This is going ok.

Trouble is, in the database table Smith_Customer,  Custom Textbox #1 (called UDTB1) is a varchar(50), whereas the special instructions allowed 500 characters. 50 characters is not much for a box I'm trying to use instead of special instructions.

So here is my question:

• If I go into the database and change the UDTB1 field in the Smith_Customer table to be varchar(500), it seems to work fine. I tested this. Is it ok to do this? Will it mess up future upgrades?
• Alternatively I can go into Step1.ascx and set MaxLength="50" for txtUDTB1, in order to prevent user input from being truncated. But 50 chars isn't much...

Please advise?

Thank you,

Daniel.

Thanks Kevin,

I think you misunderstand though.

If I make the textbox multiline, then the number of characters entered by the user becomes unrestricted regardless of the ascx code. The user can type a million characters into an ASP multiline textbox, but only the first 50 will be saved and the rest will be lost. Try it for yourself with a multiline text box.

The reason that truncation occurs at 50 characters is because the field in the actual database table that I mentioned above is restricted to 50 characters (by whoever first designed that table). If I wish to allow more characters, then I have to change this field in the database to varchar(1000) or something big like that. This seems to work ok, I just wanted to hear your developer's opinion on this customisation regarding whether it might break future upgrades.

Thanks,

Daniel.

Thanks Scott, I have submitted this.