> entry:find({{date_part, year, created},'=',2008}).
>
> This would call "SELECT * FROM entry WHERE year(created) = 2008".
>
> Would that satisfy your requirements?Yes, for finding entries by a given date that would be good. How about finding dates where entries have been posted in? So I could display on my archive index the years (eg. 2008,2007,2006) if there are entries posted in this years. If I am on a year detail page, I want to show the month entries have been posted in. Instead of the star selector I want to query for "SELECT YEAR(created) FROM entry" and "SELECT MONTH(created) FROM entry WHERE YEAR(created) = 2008". I also need it for the sidebar and that would meet all the requirements then for making archive pages. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "erlyweb" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en -~----------~----~----~----~------~----~------~--~---
