Re: [GENERAL] [SQL] [ADMIN] Is there anyway to...

2006-11-09 Thread Richard Huxton
[EMAIL PROTECTED] wrote: i'm wanting to learn something here so i'm going to chime in. the way i read what you are saying is that you'd have start_date and number_days columns in your table. each day a query would run and pull the start_date and numbers_days columns. the application (or postgr

Re: [GENERAL] [SQL] [ADMIN] Is there anyway to...

2006-11-08 Thread operationsengineer1
> While you could setup a cron job to decrement some > counter every day, I > think that's not the best approach. Instead, I'd run > a query once a day > that finds all students that are past-due and takes > some kind of action. > -- > Jim Nasby > [EMAIL