Hi,
I would like to know where is the billing address gets stored. I know that shipping address gets stored in the "address_book" table. And also, Is there a way to know which table serves what purpose as there is no description added in the table definitions. Sometimes, its a bit confusing as there are too many tables.
I also checked that there are no foreign constraints. Is there any specific reason behind it?
Thanks in advance.
I want to add a validation for postal codes. Currently we are restricting the delivery of our product in certain areas only. Hence I need to check whether the entered post code in shipping address is one among the covered areas only.
Do I need to add a custom table for that? How custom tables are accessed as the database layer is abstracted in Konakart.
Thank you.
Can anyone please help me? I am stuck .
Thanks.
U have access Custom table
<%@page import="com.konakart.db.KKBasePeer"%>
List<Record> result= KKBasePeer.executeQuery("Select * from customtable");
for (Record rs: result) {
int x= rs.getValue("colName1").asInt();
String y= rs.getValue("colName2").asString();
}
Thanks a lot for your reply.