search for: library_dates

Displaying 1 result from an estimated 1 matches for "library_dates".

2007 Apr 09
1
help with ActiveRecord joins
...lists specific dates for an event, and with a recurrences table, which specifies the rules by which an event recurs. I then have a table which simply enumerates dates up to an event horizon, and I get all events on dates in whatever range I''m looking at with a query like: SELECT events.*, library_dates.start_date FROM library_dates LEFT OUTER JOIN events ON 1=1 WHERE events.id IN (SELECT event_id FROM recurrences WHERE monthday IS NOT NULL AND DATEPART(dd, start_date) = monthday OR (monthday IS NULL AND weekday IS NOT NULL AND DATEPART(dw, start_date) = weekday AND (monthweek IS NULL OR d...