|
 |
asp_databases thread: limiting times data is extracted
Message #1 by "Chuck Murphy" <bigbat70@m...> on Thu, 25 May 2000 20:36:13
|
|
Anybody have an idea how I would code to control the number of times data
is extracted from a data base, i.e:
My end user has a data of coupons with expiration dates, and I want to
conrol the data extracted, once he retrieves a coupon, he can't retreive it
anymore.
Thanks,
Chuck
Message #2 by "Mukul Jain" <jainmukul@h...> on Fri, 26 May 2000 07:23:43 IST
|
|
add a field let say "isExtracted" as boolean in the table, and once the
record is retrieved then make it marked true. I think this will go around
what u want...
:)Smiles
Magic Guy
From: "Chuck Murphy"
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] limiting times data is extracted
Date: Thu, 25 May 2000 20:36:13
Anybody have an idea how I would code to control the number of times data
is extracted from a data base, i.e:
My end user has a data of coupons with expiration dates, and I want to
conrol the data extracted, once he retrieves a coupon, he can't retreive it
anymore.
Thanks,
Chuck
Message #3 by "Ken Schaefer" <ken.s@a...> on Fri, 26 May 2000 13:23:33 +1000
|
|
You'll need to store the fact that a coupon has been used in the database
somewhere.
Create a table with coupons.
Create a table which stores UserIDs and CouponIDs, and create referential
links to the Users and Coupons table.
When a user uses a coupon, stick an entry into the User/Coupon "link"
table.
Whenever a user tries to use a coupon, see if an entry is already in this
table, if not, then they can use the coupon, if there is, then don't let
them use it again.
HTH
Cheers
Ken
----- Original Message -----
From: "Chuck Murphy"
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, May 25, 2000 8:36 PM
Subject: [asp_databases] limiting times data is extracted
> Anybody have an idea how I would code to control the number of times data
> is extracted from a data base, i.e:
> My end user has a data of coupons with expiration dates, and I want to
> conrol the data extracted, once he retrieves a coupon, he can't retreive
it
> anymore.
> Thanks,
> Chuck
>
Message #4 by "Robert Larsson" <robert.l@m...> on Fri, 26 May 2000 10:05:44 -0700
|
|
Make a counter for each user for each coupon.
Mvh,
Robert Larsson!
Web-production Coordinator
---------------------------------------------------------------------
Mindflow AB | www.mindflow.se | 08-545 635 10
----- Original Message -----
From: "Chuck Murphy"
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, May 25, 2000 8:36 PM
Subject: [asp_databases] limiting times data is extracted
> Anybody have an idea how I would code to control the number of times data
> is extracted from a data base, i.e:
> My end user has a data of coupons with expiration dates, and I want to
> conrol the data extracted, once he retrieves a coupon, he can't retreive
it
> anymore.
> Thanks,
> Chuck
>
Message #5 by "Chuck Murphy" <bigbat70@m...> on Tue, 30 May 2000 16:44:1
|
|
Thanks Magic Guy!!!!!
Chuck
On 05/26/00, "Mukul Jain" wrote:
> add a field let say "isExtracted" as boolean in the table, and once the
record is retrieved then make it marked true. I think this will go around
what u want...
:)Smiles
Magic Guy
From: "Chuck Murphy"
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] limiting times data is extracted
Date: Thu, 25 May 2000 20:36:13
Anybody have an idea how I would code to control the number of times data
is extracted from a data base, i.e:
My end user has a data of coupons with expiration dates, and I want to
conrol the data extracted, once he retrieves a coupon, he can't retreive
it
anymore.
Thanks,
Chuck
|
|
|
View Cart
