Run a script which runs once in a while (say once a week) and checks these rows 
and deletes them.

--
Satish

chandrashekhar mekala <[EMAIL PROTECTED]> wrote:                                
  Hi all,
    
 On completing the registration process in our website 
 we are storing the date & time of registration, 
 activation flag along with the user’s personal details. 
 
 And we send a confirmation mail to user’s email account. 
 If user unable confirm his registration within 24 hrs, 
 his record has to be removed from table automatically.
    
 How to do this? 
    
 Please help……
    
 Environment:
   Apache 2.0.51
   MySql 4.1.13a
   JSP 
   Tomcat 5
   Linux.
    
    
 Thanks in Advance,
 Chandrashekhar Mekala.
 






------------------------ Yahoo! Groups Sponsor --------------------~--> 
Check out the new improvements in Yahoo! Groups email.
http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/NhFolB/TM
--------------------------------------------------------------------~-> 

=====================================================
      Mark your calendar for the next TSM
      Saturday (5pm - 8pm) on 29th July 2006

      Clustering & High Availability
      Technology and Programming Models

      What are clusters and why use them ?
      Basic Cluster Architecture
      Cluster Systems
      Cluster Software Products

      Cluster technology
      - vs Parallel computing
      - vs Distributed Systems
      - vs SMP
      - vs NUMA

      Basic Programming Models
      - Shared Model
      - Message Passing Interface
      - STAPL

      High Availability
      - FailOver
      - FailOver processing Model
      - HeartBeat, Events
      - Data Failover
      - Communication FailOver

      Clustering & HA Illustrations
      - Linux clusters 
      - MySQL clusters 
      - Appliance clusters (Firewall)

      Venue:
      CommVault Systems Pvt Ltd
      5th Floor, Conference Room
      Ashok Janardhan Chambers
      1-10-72, S.P. Road
      Begumpet
      Hyderabad - 500016 

      Helpline:
      +91 - 99499 91585
      +91 - 99496 50605 

      To know more about TWINCLING Society
            http://www.twincling.org/
===================================================== 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/twincling/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to