some help me with dates

[Newsgroup_User]

Hii,

USING ASP AND ACCESS

I am implementing a classified section for my website and I am displaying
everything successfully.

When the user posts the classified he selects how many days he wants his
POST like 10 days, 20 days or 30 days and i can successfully show the posts

So if the user posts on says 1st of July 2006 and selects 10 days for his
post to be showed on my website

THEN

8th July 2006 an email shud go to him saying if he wants to keep his POST
for another 10 days, 20 days or 30 days with 3 links

and IF YES the 1st july 2006 date must be changed to

Date of Post + Number of days selected initially + Number of days selected.

I am using two columsn in the DB for this date thing one is the strPostDate
and strAddDate

So basically the number of days selected for the post to be shown on the
website keeps adding up each time the user clicks on the link for 10 days,
20 days or 30 days with 3 links

please help need it badly :-)

thanks in advance!

[kodemonki]

Um, did you have a question?

[Newsgroup_User]

yeah i did and really need help

[Newsgroup_User]

What specifc part of the process do you have trouble with, or do you not
know how to achive the whole thing.

Firstly ASP does not have the ability to run a script without user
interaction so you are going to have to place your reminder script on a page
that gets called most days. Secondly you are going to have to hand code a
lot of this as DW code will not help you.

As you only want this to be sent once you will need another field in the
database called reminder sent.

To send out the emails you would create a SQL statement that used the
DateDiff function that will return a value once you are close to the
reminder date. If you want this sent 2 days before the expiry then if would
be something like this

Select * from table
Where DateDiff("d",strAddDate,date()) <=2 and Reminded = 'No'

Then you place a mail script inside of the recordset loop to send out the
mail, and and then run an Update Query to changed Reminded to 'Yes'. The
email should contain a link to bring the person back to an update page.

The script behind this page will use the strAddDate value as a base in a
DateAdd function to create the new dates, and you then simply run an update
statement.

It may pay to have a look at the sample scripts on www.asp101.com to come to
terms with how to write the code.



--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Techy" <anwar@clickbahrain.com> wrote in message
news:ea4a9e$shd$1@forums.macromedia.com...
> Hii,
>
> USING ASP AND ACCESS
>
> I am implementing a classified section for my website and I am displaying
> everything successfully.
>
> When the user posts the classified he selects how many days he wants his
> POST like 10 days, 20 days or 30 days and i can successfully show the
> posts
>
> So if the user posts on says 1st of July 2006 and selects 10 days for his
> post to be showed on my website
>
> THEN
>
> 8th July 2006 an email shud go to him saying if he wants to keep his POST
> for another 10 days, 20 days or 30 days with 3 links
>
> and IF YES the 1st july 2006 date must be changed to
>
> Date of Post + Number of days selected initially + Number of days
> selected.
>
> I am using two columsn in the DB for this date thing one is the
> strPostDate
> and strAddDate
>
> So basically the number of days selected for the post to be shown on the
> website keeps adding up each time the user clicks on the link for 10 days,
> 20 days or 30 days with 3 links
>
> please help need it badly :-)
>
> thanks in advance!
>