Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to automatically delete a member from database

 
Murasoli Maran
Ranch Hand
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
i have to delete members who join the website NOT making a purchase within 4 days.how can achieve the task?
may i use JSP for it or database trigger?.anybody having any pattern?.
anybody experienced plz suggest
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Murasoli,
A database trigger is well suited for this task. You could have it run regularly (for example, every night) and delete the members you specified.
 
Murasoli Maran
Ranch Hand
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thank u Jeanne.good advice from u.i decided to use trigger.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65218
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the JDBC forum.
bear
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic