Keith Devens .com

Entry 905

I put the creation and modification dates and times under each weblog entry. Which is better, with them or without them? Please let me know (like anyone comes to this site anyway .

Thing is... entries created before I started saving the modification time don't have one, so they look silly. Check out my archive and see what I mean. If I leave the timestamps, it'll incentivize me to run some SQL to update the records with empty modified times to set them to the created time for the record. I've been reluctant to run it up until now because there's always the chance I could run it by accident without putting the "where" clause in or something (which means that it would update every record, not just the ones with blank modified times), and basically I wouldn't feel comfortable unless I backed up the database first. That's always a pain, so I avoided it. The less "danger" the better.

Anyway, the SQL is simple, so I'll probably do it soon and not worry about it. "update blog set updated_time = created_time where modified_time is null" (table and field names have been changed to protect the innocent).

Permalink | Comments? | id 905

04:03 (utc-5)
edited: 04:16 (utc-5)