Create An Account Form

[NickSMM]

Hi,

I have a small problem with the form, particularly the Company Details: Company Names.

Currently I think the character limit (value) is at a maximum of 30, is there anyway into increase that to say, 50?

Thanks,
Nick

[DrByte]

Yes - go to Admin->Tools->Install SQL Patch, and paste the following into the box, and click Send:

ALTER TABLE address_book MODIFY entry_company entry_company varchar(64) default NULL;
ALTER TABLE orders MODIFY customers_company customers_company varchar(64) default NULL;
ALTER TABLE orders MODIFY delivery_company delivery_company varchar(64) default NULL;
ALTER TABLE orders MODIFY billing_company billing_company varchar(64) default NULL;

(Yes, xxxxxx_company is repeated intentionally.)