One of the first articles about the Service we wrote in Coldfusion and Fusebox is up on Handshake 2.0.

http://www.handshake20.com/2009/04/furnishweb-delivers.html

Handshake 2.0 is a cool idea to use the internet to get your products and or company noticed when you don;t have the time to blog or you;re just not that good at it :)

http://www.handshake20.com/how2useh20.html

I finally found the correct information today to figure out why some kinds of subqueries take forever to come back in mysql. If you are using a subquery with a MYSQL IN() like this:

select o.ack,o.product
from orders o
where o.ack in (
select distinct ack
from 	orders
where  	status in ('Shipped','Cancelled')
group by ack
having 	DATE_ADD( DATE_SUB( now( ) , INTERVAL DAYOFMONTH( now( ) ) - 1 DAY ) , INTERVAL -3 MONTH ) > max(status_date))
)
order by o.ack, o.line

It takes a few minutes to return a result. If you take the same query and reorder it to put the subquery in the from with a join it comes back almost instanty :

select o.ack,o.product
from orders o
inner join (select distinct ack
from 	orders
where  	status in ('Shipped','Cancelled')
group by ack
having 	DATE_ADD( DATE_SUB( now( ) , INTERVAL DAYOFMONTH( now( ) ) - 1 DAY ) , INTERVAL -3 MONTH ) > max(status_date)) old_o
on o.ack = old_o.ack
order by o.ack, o.line

It's interesting on MSSQL that the IN() subquery syntax is much faster.

Here's a link to the bug report:

bugs.mysql.com/bug.php (Thanks Jeremy Pointer :) )

I was very excited my New Mac Book Pro got here yesterday. It is so much faster than my old G4 Powerbook :). My old laptop wrote a lot of great code and it will be fondly remembered.

I was rolling along getting my music and mail copied over ( important stuff first :) ) and having a grand time with the new multi-touch track pad. That I thought I would brave the install of Coldfusion on Leopard.

I figured since there were posts going back to OCT 2007 I'd be safe, by getting my laptop now. How wrong I was. After 7 hours of not working and trying all of the blog posts and suggestions the web had to offer I had almost given up. When I came along this blog post with a video :

www.flashalisious.com/2007/12/14/installing-coldfusion8-on-leopard-using-mamp/

Well that worked after many hours of frustration so kudos for figuring this out and saving the day.

On a side note the weakest part of coldfusion since they have switched to java has been the installer. Even on linux systems they do offically support. I think it really hurts us as a developer community. It's fine if Adobe doesn't support every operating system in th world but it should at least install and function for development. And they do support OS X just not this version. I would have expected them to have had a fix for this by now. It's a huge barrier to developers even more so than the costs associated with buying the server. My New Mac came already working with PHP ....

Oh well off to setup CFECLIPSE :)

*Update 3/19/2008 - I got an email from Adobe for the Beta Test of CF8 Beta 1 waiting to get the download.