Page refresh issue 1

[Hondy]

Hi

I have a page that pulls data from a database, when a condition is met an email is sent off. This works fine.

The page auto-refreshes every 10 minutes but if the same condition is met again it sends out another email.

Is there any solution to let it only email once then that is flagged as complete so the only emails I recieve is for new conditions? I don't want to write to the database, i'm not sure this is possible actually but I'm open to ideas...

Thanks

 

[Kendel]

I would use the session object after I send off the email. When the page refreshes, check the condition and the session.

 

[Hondy]

is that difficult? I'm not a programmer so is this out of my league? Any resources?

 

[Kendel]

Not at all. Something like this:

'Put this line inside your send email sub, after the email is sent out successfully

session("sendEmail") = "Done"

'Then you check the condition & session the next time you want to send out the email 

If someCondition = "yes" and session"sendEmail" <> "Done" then
   ...

 

[Kendel]

sorry ...typo .. shouldbe

If someCondition = "yes" and session("sendEmail") <> "Done" then

 

[Kendel]

Check out the ASP tutorial for session objects:

http://www.w3schools.com/ASP/asp_sessions.asp

 

[Hondy]

great, i will check that out tomorrow

Thanks