Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Somebody can help me?


Veronica

Recommended Posts

Posted

I have a problem, I need to put I number of the DNI in Spain is the national document of indentity. One is made up of 8 numbers and one letter xxxxxxxx-A

 

I want it to put in the field of the date of birth and to put it as obligatory but I do not know how to change the format predefined for the birthday that is xx/xx/xxxx please if somebody has done it, he knows how to do it or he knows of some contribution that helps me would thank for it enormously

Posted

Firstly you will need to make changes to the customers_dob field in the customers table via phpmyadmin or whatever tool you are using.

 

Change the type to varchar and the lengths/values to 8.

 

Then alter catalog/includes/languages/english.php or whatever you are using. Around line 212 change the text to DIN number.

 

Hope that works :)

Posted

Thanks to answer to me. I have tried to put in practice which you have said to me but I embroil in phpmyadmin that is the tool that use.

 

Your you have said to me: Change the type to varchar and to lengths/values to 8.

 

And I see: VARCHAR, TINYINT, TEXT, DATES, SMALLINT, MEDIUMINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL, DATETIME (predefined for the birthday), TIMESTAMP, TIME, YEAR, CHAR, TINYBLOB, TINYTEXT, BLOB, MEDIUMBLOB, MEDIUMTEXT, LONGBLOB, LONGTEXT, ENUM and SETH.

 

I do not know which of all I must put, you could specify to me more, thank you very much

Posted

I have already obtained it but there are other fields that I believe that it would have to modify: ATTRIBUTES, NULL, DEFAULT and EXTRA

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...