if you could only use CF.. why?
Do people log in to the site? if so that would be easiest.. you would
just store the Date, couponID, and who downloaded it.. Then you could
query off that table to see when they last downloaded it.
If you're using Oracle.. it'd look something like
SELECT *
FROM coupons
WHERE UserID = '#userID#'
AND couponID = '#couponID#'
AND date_downloaded BETWEEN ADD_MONTHS(TRUNC(SYSDATE),-1) AND TRUNC(SYSDATE)
if any records are returned.. then it's been downloaded previously.
That help?
On Tue, 28 Sep 2004 17:53:19 -0400, Phillip Perry
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> What I'm trying to do is make a coupon page where if the user clicks on a
> link to print the coupon out, the user cannot print out that coupon again
> for 1 month. This is so people don't print coupon after coupon after coupon.
> I know how to do links but what kind of command do I give CF to tell it to
> wait 1 month and to keep track of the days.
>
> I hope that made some sense.
>
> Phillip Perry
>
> ============================================
> InterDesign
> Designing Tomorrow, Today!
> 52 Franklin Ave.
> Box 22
> Clinton, N.Y. 13323
> 315.853.8028
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
