![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Ahaha userpic.
Oct. 15th, 2007 09:09 amI am loving my tasks thing.
Right now, I'm teaching myself about triggers for MySQL. The Tasks table has the columns Completed, Deleted, and DateAdded, which have default values of 0, 0, and Now(), respectively. Instead of putting that into the ASP page, I want it so that inserting a new row in Tasks adds those items automatically.
I'm not sure if having a trigger that does that means I can't have those columns be not null. But I'll find out! Brilliance.
If I get this done, I'll totally put this somewhere so that others can run off with it.
Things left:
- Get the actions working (complete/edit/delete).
- Have an export-to-.csv function.
- Have an Empty Trashcan-thing action, if there are items to be deleted.
- Have a way of disabling that.
- Filter on tags!
- Column chooser!
- Sort/filter on whatever I want! (I only want to filter on tags, but hey, why not?)
- Dance!
Right now, I'm teaching myself about triggers for MySQL. The Tasks table has the columns Completed, Deleted, and DateAdded, which have default values of 0, 0, and Now(), respectively. Instead of putting that into the ASP page, I want it so that inserting a new row in Tasks adds those items automatically.
I'm not sure if having a trigger that does that means I can't have those columns be not null. But I'll find out! Brilliance.
If I get this done, I'll totally put this somewhere so that others can run off with it.
Things left:
- Get the actions working (complete/edit/delete).
- Have an export-to-.csv function.
- Have an Empty Trashcan-thing action, if there are items to be deleted.
- Have a way of disabling that.
- Filter on tags!
- Column chooser!
- Sort/filter on whatever I want! (I only want to filter on tags, but hey, why not?)
- Dance!
