Hello, I am tracking peoples IP address so they can only vote 1 one. But i want them to be able to every week. So i want to be able to delete all the IP address from the datbase every week. i was wondering if i can set it up so it does it automatically, or would i have to manually do it every week.

You can do it automatically through a number of ways.
1. If your DB is SQL Server you could set it up in a SQL job (I am sure other server DBs such as Oracle have similar functionality, but I am not aware of it).
2. You could store a date with the IPAddress and in your code check if it is past a week. If so, change the date and allow the query to continue, otherwise abort the process.
3. Assuming you are on a windows platform (a fair assumption for ASP) you could use a windows scheduled task to execute a script and delete from this table. Similarly, you could set up a service to do the same thing.

I am sure there are many other ways, but these are the first three that come to mind.

Yehuda

What database do you use?

_________________________
- Vijay G
Strive for Perfection

How I did it in a similar situation is like this.

In my system, admin will make a poll live. So when a new opinion poll goes live, I deleted all IP addresses from database. Check whether this is possible in your case.

The scheduled deletions has got a drawback in my context. They will work every week at the same time. But the new poll may not be ready by that time. That is why I had to do it in this way.

MS Access

You can write a vbs file that deletes all the IPs and use windows schedule task to run it at a time just before the next poll goes live.

Or

As madhu suggested you can go ahead and delete the IPs before the next poll goes live from within your web app, as that would be easier to control deletion from within your application, instead of doing it from an external application which you got to reschedule in case there is a change in the time when the next poll goes live.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection