Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › How to make a note field longer on the checkout page?

How to make a note field longer on the checkout page?

Thread began 7/18/2013 2:50 pm by elewis93815 | Last modified 7/22/2013 8:54 am by Jason Byrnes | 930 views | 3 replies |

7/18/2013 2:50 pm | #1 elewis93815

How to make a note field longer on the checkout page?

We have created a "special notes" field on the checkout page of our clients store. It appears that the note is either cutting off and or not coming over at all. I have checked the order database and the varchar is set to 3000 so I'm not sure what the problem is????? I have attached the files if needed.

Attached Files

WA NOTES FIELD.zip

7/18/2013 3:19 pm | #2 Jason ByrnesWebAssist

the maximum number of characters a varchar field can store is 255

try changing the data type in the orders table to text instead.

7/22/2013 8:50 am | #3 elewis93815

Hello Jason,

I discovered that it is not the length of the note that is causing a problem but any special characters that are included in the note. e.g. Today is "Monday" and it's a nice sunny day! This note will cut off and not show as soon as a " (quote) is added. If I remove the quote, the entire note will show. Are there any preferences that can be set to allow any special characters?
Thanks,
Jackie

7/22/2013 8:54 am | #4 Jason ByrnesWebAssist

the quotes need to be converted to HTML entities.

In the store order summary behavior, when you dind the note column to the note field, set the formating to Encode - HTML Encode.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.