The blog filled with creative thoughts
<< a life's mystery  |   ARCHIVES  |   what would you bring back in time?>>

all old entries from blogger have been entered

But the archives don't seem to be working properly. I wonder why. Do i need to set something up special for them?


Posted by: spudart on Jul 21, 03 | 6:14 am  |   [2065] Hits  |   permalink

leave a comment facebook comments below
leave a comment1 archived comments below


The archives are now working properly. When the previous blogger entries got imported the dates didn't have leading zeros. Like: 7/9/2003 should be 07/09/2003.

I thought it was gonna be a pain adding a zero for each date through the database (lots of clicking and submitting the form for each individual record of over 400 records). BUT, it was so easy to change. Just went into the database and changed the fields for day and month from a two-character STRING to a TINYINT with ZEROFILL attribute. Ohmigosh. It was so easy. That fixed it!

Posted by: spudart on Jul 22, 03 | 8:40 pm


Welcome
Hi. I'm Matt Maldre. Every single weekday my blog on spudart.org has a new post with an original idea or discovery. Be sure to stop by daily to see what's happening.




for sale
Buy some art
Opposing Heights - print at deviantart.com
-->
mailing list
Get new spudart posts once a day:

Enter your email address:

Delivered by FeedBurner


Subscription Center
Subscribe via RSS
Add to Google Reader
Add to My Yahoo
Add to My AOL
Add to My AOL
Add to My MSN
Add to My MSN
Subscribe in NewsGator Online
Add to NewsGator
Add to Bloglines
Add to Bloglines