How to increase CUstomer Address Lenght?

[rocdy]

Anyone know how to increase Customer Address Lenght?

 

I have tried to change it in the database use phpmyadmin. But it doesn't work.

 

If anyone know how to increase the Customer Address Lenght please post it here.

 

Thanks

 

Best Regard

Rocdy

[multimixer]

The way IS the database

 

Go to the table address_book, find the field entry_street_address and change the varchar value to something higher than 64

[rocdy]

The way IS the database

 

Go to the table address_book, find the field entry_street_address and change the varchar value to something higher than 64

 

I have try that before, i change entry_street_address from varchar(64) into varchar(128) and it still not change my customer addres length.

 

I know that when i try to edit my customer address in admin side.

 

Any idea about that?

Thank before.

[FIMBLE]

I have try that before, i change entry_street_address from varchar(64) into varchar(128) and it still not change my customer addres lenght.

 

I know that when i try to edit my customer address in admin side.

 

Any idea about that?

Thank before.

Are you trying to do this for existing customers or for new customers, as there are at least two entries in the database

Table address book

table orders

Nic

[rocdy]

I have try that before, i change entry_street_address from varchar(64) into varchar(128) and it still not change my customer addres length.

 

I know that when i try to edit my customer address in admin side.

 

Any idea about that?

Thank before.

 

 

Oh, i find some good trick. Maybe this are the solution.

 

http://www.oscommerce.com/forums/index.php?showtopic=313117

 

I just change the length of the input field. So i can edit customer address base on the limit in database varchar(128)

 

:)

[FIMBLE]

confused now :'(

[rocdy]

confused now :'(

 

Sorri. Maybe is my fault. i will explain more.

I have increase address length in the database, but i forgot to change the input fields in catalog/admin/customer.php:

 

echo tep_draw_input_field('entry_street_address', $cInfo->entry_street_address, 'maxlength="64"', true);

 

and i can't input more than 64 character.

 

than i change 'maxlength="64" into 'maxlength="128" :

 

echo tep_draw_input_field('entry_street_address', $cInfo->entry_street_address, 'maxlength="128"', true);

 

and i can write more than 64 character now.

 

Sorri for my bad English.

:)

[FIMBLE]

right, so you wanted the input boxes wider, i see now.

Your English is fine.

Nic