[ic] Maintaining Session

fctmaillist interchange-users@interchange.redhat.com
Sat Oct 20 19:45:49 2001


Hi kyle,
    Its true that the shipping address details are maintained in the userdb
table in
a column named address_book, but i want to clarify how shipping address
details for orders made are maintained. Suppose i buy 3 items, i can ship
all the 3 items to three different shipping addresses.
There are no fields available as of now in the orderline table.
Do u have any idea of the same ?
Balaji
----- Original Message -----
From: Kyle Cook <kyle@invisio.com>
To: <interchange-users@interchange.redhat.com>
Sent: Friday, October 19, 2001 1:39 AM
Subject: Re: [ic] Maintaining Session


> At 09:25 AM 10/19/01, you wrote:
> >Hi,
> >     Can someone plz clearly state me about the two database files namely
> >  transactions and Orderline. As far as the document specifies it says
that
> >  each and every item of an order are
> >  stored in the orderline table whereas a summary of the order is stored
in
> >  the transactions table.
> >
> >  I.e., There lies a one to many relation between the transactions and
> >  orderline wherein every parent
> >  record in the transaction table there is one or many child records
> >available
> >  in the orderline table.
> >
> >  I guess iam clear in my understanding. If not pls correct me.
> >
> >  Well, my question is, if this is  the case then how multiple shipping
> >  locations are taken care.
> >  Coz the current structure of the orderline table doesn't seem to have
> >  sufficient columns for the same. Moreover the demo avl (foundation
catalog)
> >seem to accept ship
> >  address for each and every item purchased, but at checkout it still
asks
> >for a shipping
> >  address.
> >
> >  Can someone plz do correct me if iam misunderstood ??
> >  Thnx in advance.
> >  Balaji
>
> It's been a while since I've had the chance to use the actual database
> structure
> as is, constantly doing custom db schemes.
>
> I know that at one time , multiple ship to addresses were saved in userdb
for
> logged in users.
>
> Hope this helps.
> Kyle
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users