« April 2010 | Main | June 2010 »

May 20, 2010

Overlapping dates revisited

select distinct s1.resident_slot_id 

from eclub.resident_slot s1,  eclub.resident_slot s2 

where 

s1.start_time < s2.end_time 

and 

s2.start_time < s1.end_time 

and 

s1.resident_id = s2.resident_id 

and 

s1.resident_slot_id != s2.resident_slot_id 

and s2.expired_date is null and s1.expired_date is null

Posted by pj at 04:21 PM | Comments (0)

May 13, 2010

jQuery Gallery with Flikr hooks

Galleria — A JavaScript gallery for the Fastidious

Posted by pj at 03:35 PM | Comments (0)

Creating a YouTube Gallery using jQuery Fancybox

Creating a YouTube Gallery using jQuery Fancybox - Aaron Benson | DFW Interactive Designer/Developer | Flash Enthusiast

Posted by pj at 03:34 PM | Comments (0)

May 07, 2010

JQuery $.get() caching in IE 7

Having extensively used jQuery AJAX all over the site we built in Feb have now discovered that IE 7 caches GET requests if the URL is the same? WTF? That's helpful for regularly updated feeds. Thanks MS. My day will now consist of finding every GET call in every CMS page and application script and pasting { blah : 1 , 'random' : Math.floor(Math.random()*1000 ) } into it. RSI here we come.

Posted by pj at 01:22 PM | Comments (0)