HomeHome Product Discus... Product Discus...SmithCartSmithCartIncrease size of Text Box at checkoutIncrease size of Text Box at checkout
Previous
 
Next
New Post
6/30/2011 12:17 PM
 

We need to increase the number of characters that "Textbox #1" under "Checkout Setup Step 1" in System Settings can save.

We're using it as a place for customers to add a gift card. Now it only enables the user to input 23 characters.

In the Smith_Customer table the field UDTB1 is where the data is saved. It's set to Varchar(50). Can I just increase the size to (250) and make corresponding updates to Smith_AddCustomer and Smith_UpdateCustomer stored procedures?

Would I need to update any other fields/sp/views?  

Thanks

 
New Post
6/30/2011 7:18 PM
 

Hi Stan,

Please see the following forum post for information on how to increase the number of characters allowed in the text box:
http://www.smith-consulting.com/Forum...

Thanks

 
New Post
7/12/2011 3:41 PM
 

I've followed the steps in the other thread, but to no avail... it ends up referencing a different issue.

I need to make the UDTB1 field in the customer table accept more characters.

This is what I've done so far.

This is the updated from the Step1.ascx so I have a larger input field.

  

In the Database:

Updated the field UDTB1 in the Smith_Customer to be varchar (500).

Updated the SP:

Smith_UpdateCustomer and Smith_AddCustomer so the UDTB1 field is varchar (500)

What else do I need to do?

 

UPDATE:
I was able to run an update query with a long copy block and it updated the field okay... the problem is getting the copy into the field from the form.

 
New Post
7/13/2011 3:30 PM
Accepted Answer 

Don't know what happend, but the text is now being saved.

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartIncrease size of Text Box at checkoutIncrease size of Text Box at checkout