Displaying 2 results from an estimated 2 matches for "record5".
Did you mean:
record
2008 Sep 23
3
Finding distinct months using find_by_sql
...g to get the distinct months (and years) from a date field to
display as a list in a view. For example, there might be a number of
records stored with dates in the table ''headlines'':
name date
record1 21-09-2008
record2 15-09-2008
record3 03-08-2008
record4 02-08-2008
record5 12-07-2008
etc.
From which I''d like to get all distinct years and months to display in
a view something like what might be seen under the ''Archives'' section
of a blog page, like this:
September 2008
August 2008
July 2008
etc.
I have tried to set the following sql stat...
2006 Jul 20
11
3 columns
Hi all,
Not really sure what to put in the title so hope people still open this!
What I want to do is produce something like this
Col1 Col2 Col3
data1 data2 data3
data4 data5 data6
data7 data8 data9
data.. data.. data..
data.. data.. data..
data-n data-n+1 data-n+2
I can get the data back from my db