Odd Referers

By far the oddest link to my blog ever, http://www.kelleyfurniture.com/Office-Deskeg.html ... can't quite tell why they did :)

2 comments | Posted by Daniel Short on Feb 14, 2004 at 12:00 AM | Categories: Rambling -

MySQL Whooped

This is for the benefit of those of you who found as little information as I did on Google about MySQL converting dates to Binary when using DATE_FORMAT, or just about any other formatting function inside your SQL. Now, I could have sworn I'd tried this before, but I must have been high on Pepsi. Anyway, here's the SQL that was giving me binary data:

DATE_FORMAT(tbl.field,'%Y-%m-01')

And here's what I did to make it work...:

CONVERT(DATE_FORMAT(tbl.field,'%Y-%m-01'),CHAR)

Your mileage may vary, but enjoy :)

2 comments | Posted by Daniel Short on Feb 12, 2004 at 12:00 AM | Categories:

New Sales Rank Tracker Feature

You can now view book details directly from the Sales Rank Tracker. Now I don't have to go to Amazon to check the latest reviews or ratings either ;). Just call me lazy, I can take it :)

Sales Rank Tracker Book Details

0 comments | Posted by Daniel Short on Feb 12, 2004 at 12:00 AM | Categories: ColdFusion -