Help with column width

[earthbound]

I'm helping a friend with a website he had built. I have little to no knowledge of php and very little html.

 

He had a database built where you enter information on one page. name, phone, etc. And the entered data is transferred to sortable table (grid?) on an admin page.

 

The problem we are having is: when you enter a phone number, 111-111-1111, the last two digits don't show up on the admin side. It shows as 111-111-11.

 

I'm not sure if all the data isn't getting transferred? or will the column width on the admin page not allow that many characters.

 

Any help would be great and I can supply code if I need to.

[trq]

Without relevant code we cannot help much. Is this field you are talking about a text input? Can you cursor left to right and see the complete text?

[earthbound]

You can see the complete text on the input field. The problem is on the admin page, which is where this data goes. If a number is entered as 123-123-1223 on the input page, it shows up as 123-123-12 on the admin page.

 

There is so much code, I don't even know where to begin. What's the best way to get this code posted on here?

[TheGreek]

do you have access to the database to verify the field width on the column

[earthbound]

I do have access to the database. I've changed (what I thought) would fix the issue on both the input page and the admin page.

 

Here's copy of some of the code on the input page. There are many places for the phone number field where there are max length settings, this is just one.

 

            // View column for PhoneNumber field
            //
            $column = new TextViewColumn('PhoneNumber', ' Phone Number ', $this->dataset);
            $column->SetOrderable(true);
            
            /* <inline edit column> */
            //
            // Edit column for PhoneNumber field
            //
            $editor = new TextEdit('phonenumber_edit');
            $editor->SetSize(14);
            $editor->SetMaxLength(14);
            $editColumn = new CustomEditColumn('PhoneNumber', 'PhoneNumber', $editor, $this->dataset);
            $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
            $editor->GetValidatorCollection()->AddValidator($validator);
          
            $column->SetEditOperationColumn($editColumn);

[jazzman1]

Do a "view source" in the browser.