increasing the max character lengh of post code

[pronane]

I have set up a site in ireland, where we dont have postcodes, instead I use the post code text field as the "town" textfield for addressess. however the max length for postcode currently seems to be 10. I want to increase this to at least 20, and I also want to increase it in the admin page, so people that have already registered, I can update their details in the admin section.

 

Btw, I am relatively new to oscommerce so assuming their is a code change required I will need to know the name of the files to change and their location!!! :thumbsup:

 

Thanks for any help!! :)

[knifeman]

I have set up a site in ireland, where we dont have postcodes, instead I use the post code text field as the "town" textfield for addressess. however the max length for postcode currently seems to be 10. I want to increase this to at least 20, and I also want to increase it in the admin page, so people that have already registered, I can update their details in the admin section.

 

Btw, I am relatively new to oscommerce so assuming their is a code change required I will need to know the name of the files to change and their location!!! :thumbsup:

 

Thanks for any help!! :)

The address_book table in your database has this field limited to 10. Using phpmyadmin you can alter the max length of the post code field.

 

Tim

[pronane]

The address_book table in your database has this field limited to 10. Using phpmyadmin you can alter the max length of the post code field.

 

Tim

 

 

yes but arent the text fields/boxes themselves limited to 10 also? I mean a user cant actually enter more than 10 characters?

 

Also if I just need to update hte address_table, in the admin section it still only allows me to enter 10 characters...

[knifeman]

yes but arent the text fields/boxes themselves limited to 10 also? I mean a user cant actually enter more than 10 characters?

 

Also if I just need to update hte address_table, in the admin section it still only allows me to enter 10 characters...

I went to one of my sites and it let me enter well over 10 characters in the post code box on create account page, but it truncated it to 10 on the next page.

 

Tim

[pronane]

yes but arent the text fields/boxes themselves limited to 10 also? I mean a user cant actually enter more than 10 characters?

 

Also if I just need to update hte address_table, in the admin section it still only allows me to enter 10 characters...

 

 

ok the fields are not limited, a user can enter as much as they want, but they get cut off when they are being sent to the database. however the second point is still valid, in the admin section you are unable to enter in anymore characters in the post code field. its just the post code field. this makes no sense.

[knifeman]

ok the fields are not limited, a user can enter as much as they want, but they get cut off when they are being sent to the database. however the second point is still valid, in the admin section you are unable to enter in anymore characters in the post code field. its just the post code field. this makes no sense.

I see that now. My admin limits me to 8 charcters in that field. Not sure where to change that one. Can you alter the length of post code in the database, then alter existing customers there as well?

 

Tim

[pronane]

I see that now. My admin limits me to 8 charcters in that field. Not sure where to change that one. Can you alter the length of post code in the database, then alter existing customers there as well?

 

Tim

 

ya i can do that tim, but I wanted to do it through the admin less messy...

[knifeman]

ya i can do that tim, but I wanted to do it through the admin less messy...

I agree, I don't like messing in the Db unless necessary. I have been looking through the files, but I don't see where that field is being limited. Maybe someone else can point you the right way.

 

Tim