How can I update a custom column in database?

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
nowa
Ensign (ENS)
Ensign (ENS)
Posts: 1
Joined: Mon Nov 29, 2010 6:38 am

How can I update a custom column in database?

Post by nowa » Wed Dec 01, 2010 2:03 am

Hi, when a user is edited or saved in admin cp I want to set a datetime value to a field and in the addresses table. How Can I do that in version 705? What files do I probably need to edit?
Last edited by nowa on Mon Dec 13, 2010 1:47 am, edited 1 time in total.

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: How can I update a custom column in database?

Post by mazhar » Wed Dec 01, 2010 5:10 am

Well address table doesn't contain any of two fields you mentioned. So first of all you need some place in database where you can save this information. Instead of modifying address table better try putting extra fields information in some different table and then linking it to corresponding address. For example you can utilize ac_CustomFields for this purpose. Reade following thread about how to use ac_CustomFields table viewtopic.php?f=42&t=8651

Post Reply