Print Page - DB table for addresses

Title: DB table for addresses
Post by: pooja on April 03, 2014, 08:03:59 pm

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.

Title: Re: DB table for addresses
Post by: pooja on April 03, 2014, 08:16:02 pm

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.

Title: Re: DB table for addresses
Post by: pooja on April 05, 2014, 11:31:31 pm

Can anyone please help me? I am stuck .

Thanks.

Title: Re: DB table for addresses
Post by: Expert Review on April 12, 2014, 02:47:05 pm

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();

}}

Title: Re: DB table for addresses
Post by: pooja on April 13, 2014, 10:57:02 pm

Thanks a lot for your reply.

KonaKart Community Forum

Installation / Configuration => Programming of KonaKart => Topic started by: pooja on April 03, 2014, 08:03:59 pm