STATE field too long

[synamax]

After checkout confirmation, the value for the customer's state (among other values) is passed to the payment processor VIAKLIX for processing.

 

Right now, the value passed over is the FULL value name of the state/province.

 

Ideally, I would like to pass over the zone_code or state/province abbreviation instead of the zone_name or full named description BECAUSE the payment processor i am using has a maximum data length of 10 characters.

 

So, for example, when i enter "South Carolina" as a customer state ... i receive an error stipulating that my STATE value was 14 and the maximum allowed is 10 characters.

 

I know that this state value is getting passed over .... but i have no clue from where .... what table does the value pull from? What page(s) control the flow of customer data values through checkout.

 

 

Thanks for all your help ahead of time.

 

 

- allen

[Guest]

seems you may have an invalid or corrupted installation, as what osCommerce does, is assign a number value to the state, which it pulls from the table.

with that in mind, what items have you modified? add any contributions?

was this function working prior to any contributions? If i install a store, I test the complete functionality of the store prior to adding any contributions, as this then lets me know I do have a clean working installation. Then, I make a complete copy of that, along with the database. If anything goes wrong, I always have a valid backup.