Casey Wise

Twitter Weekly Updates for 2010-03-07

Posted by admin | Posted in Uncategorized | Posted on 07-03-2010

0

This is the best video I've ever seen http://bit.ly/8Z9C3x #

Powered by Twitter Tools

Protected: dotCMS SQL Calendar Events with Associated Categories

Posted by Casey Wise | Posted in code, dotCMS | Posted on 19-02-2010

0

dotCMS SQL Query: Filtered course guide filters

Posted by Casey Wise | Posted in code, dotCMS | Posted on 13-02-2010

0

^?View Code SQL

SELECT DISTINCT
	d.category_name,
	d.inode
FROM
	tree a
	INNER JOIN category b
		ON a.child = b.inode
	INNER JOIN tree c
		ON a.child = c.parent
	INNER JOIN category d
		ON c.child = d.inode
	INNER JOIN tree e
		ON c.child = e.parent
	INNER JOIN category f
		ON e.child = f.inode
		AND f.active = 1
WHERE
	a.parent = 155228
	AND c.parent = "+$parentInode

dotCMS SQL Query: Dual filtered course guides

Posted by Casey Wise | Posted in code, dotCMS | Posted on 13-02-2010

0

^?View Code SQL

SELECT DISTINCT
	c.title,
	c.inode,
	c.text_area1 as 'overview'
FROM
	category a
	INNER JOIN tree b
		ON a.inode = b.parent
	INNER JOIN contentlet c
		ON b.child  = c.inode
		AND c.live=1
	INNER JOIN tree d
		ON c.inode = d.child
	INNER JOIN category e
		ON d.parent = e.inode
	INNER JOIN tree f
		ON d.parent = f.child
WHERE
	a.inode = $inode
	AND f.parent = 155153
	AND d.parent = $filterInode
ORDER BY
	c.title

dotCMS SQL Query: 2nd level subject hierarchy categories

Posted by Casey Wise | Posted in code, dotCMS | Posted on 13-02-2010

0

^?View Code SQL

SELECT 
	a.child,
	b.category_name
FROM 
	tree a
	inner join category b
		on a.child = b.inode
		and b.active=1
WHERE 
	parent = 630865

dotCMS SQL Query: Available Courses Listing

Posted by Casey Wise | Posted in code, dotCMS | Posted on 13-02-2010

0

^?View Code SQL

SELECT DISTINCT
	b.category_name AS 'subject_cluster',
	b.inode as 'clusterInode'
FROM
	tree a
	INNER JOIN category b
		ON a.child = b.inode
	INNER JOIN tree c
		ON a.child = c.parent
	INNER JOIN category d
		ON c.child = d.inode
	INNER JOIN tree e
		ON c.child = e.parent
	INNER JOIN category f
		ON e.child = f.inode
		AND f.active = 1
WHERE
	a.parent = 155228

NextGEN Photogallery Sample

Posted by Casey Wise | Posted in photography | Posted on 07-02-2010

0

Doing some work for cake decorator extraordinaires White Flower Cake. Reviewing some gallery options with NextGEN.

calla1

Praesent at nunc dui, at gravida velit. Sed eleifend aliquam lectus, ac semper felis tincidunt vel. Nulla id odio sem. Praesent id urna risus.

calla2

Vivamus ultricies nulla non quam auctor vitae elementum sem luctus.

danielle1

Maecenas pellentesque iaculis mauris, at scelerisque ante vehicula eu. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.

danielle2

falguni1

falguni2

janet1

janet2

katiew1

katiew2

stephanie1

stephanie2

janet1_0

janet2_0

katiew1_0

katiew2_0

stephanie1_0

stephanie2_0

Graphic Work: dotCMS book cover

Posted by Casey Wise | Posted in graphic work | Posted on 07-02-2010

0

Good friend and fellow developer Michael Fienen is in the throes of writing a book for the content management system we use at UA, dotCMS. We regularly IRC, he mentioned one day that he was looking for some graphics for the cover of his book. I volunteered and here’s what I came up with:

click to enlarge

And announcing… a baby

Posted by Casey Wise | Posted in family | Posted on 02-02-2010

10

For those unaware, we are expecting a baby. Until today, we referred to the size of baby growing inside as a fruit size. Amber signed up for email notifications to keep us apprised of growth progress. This week, he/she was a fig, last week a kumquat, the week before that a grape, etc. Our fig was due on Aug 29, but today that changed. We learned much more today as we had our first real doctor appointment:

1 heartbeat = 1 baby (Amber has twins in her family)
We’re due September 4, pushing us back to a kumquat
Heartrate is 166bpm, which is very normal… according to my sister, very typical of girls
There’s a lot of arm pumping, leg kicking and heart beating

click to enlarge