|
 |
asp_databases thread: A Theoretical E-commerce Problem
Message #1 by "George" <georgex1_1999@y...> on Sat, 28 Oct 2000 20:54:12 +0100
|
|
I've lately been giving consideration to a database driven e-commerce
system but am having a few problems. I was thinking a user could click
product, product then goes to order database where I can draw the
recordset's of the things they ordered when I need them. My problem is
that
I can easily get the orders into a database but how will I know which
orders belong to which user. I think I could do it if I gave each user a
username but I don't want to do that as users shouldn't have to enter
their details until later in the order process
If anyone can think of a way around this I would be grateful and then
maybe I'll actually start on it.
George
Message #2 by "peter" <ph@t...> on Sun, 29 Oct 2000 00:59:37 +0100
|
|
you'll need to learn about creating a relational database, bit much for a
list but I'd imagine asptoday.com or somewhere will have the details..
HTH
peter
Message #3 by =?iso-8859-1?Q?Jos=E9_Ernesto_Echeverr=EDa?= <ernestoe@s...> on Sun, 29 Oct 2000 07:11:31 -0600
|
|
try the session id for starters.
-----Original Message-----
From: George [mailto:georgex1_1999@y...]
Sent: Saturday, October 28, 2000 1:54 PM
To: ASP Databases
Subject: [asp_databases] A Theoretical E-commerce Problem
I've lately been giving consideration to a database driven e-commerce
system but am having a few problems. I was thinking a user could click
product, product then goes to order database where I can draw the
recordset's of the things they ordered when I need them. My problem is
that
I can easily get the orders into a database but how will I know which
orders belong to which user. I think I could do it if I gave each user a
username but I don't want to do that as users shouldn't have to enter
their details until later in the order process
If anyone can think of a way around this I would be grateful and then
maybe I'll actually start on it.
George
Message #4 by "Ken Schaefer" <ken@a...> on Mon, 30 Oct 2000 12:31:04 +1100
|
|
You need to create some kind of UserID for each user.
Store the UID in the database with their shopping basket.
Pass the UID between pages via
a) cookies
b) session variables
c) querystring
d) hidden form fields
Cheers
Ken
----- Original Message -----
From: "George" <georgex1_1999@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Sunday, October 29, 2000 6:54 AM
Subject: [asp_databases] A Theoretical E-commerce Problem
> I've lately been giving consideration to a database driven e-commerce
> system but am having a few problems. I was thinking a user could click
> product, product then goes to order database where I can draw the
> recordset's of the things they ordered when I need them. My problem is
> that
> I can easily get the orders into a database but how will I know which
> orders belong to which user. I think I could do it if I gave each user a
> username but I don't want to do that as users shouldn't have to enter
> their details until later in the order process
> If anyone can think of a way around this I would be grateful and then
> maybe I'll actually start on it.
> George
|
|
|
View Cart
