[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Records as per month

Naga harish Kanegolla

9/18/2006 1:28:00 PM

Hi,
Could anybody please help me to search the record by date

I have one products table. In that table I have created_at.I want to
search the records by date.

I mean, if i select month as january and year as 2006 then i want to get
the list as per that month only.
Ex:
Created At Product Price
2006-09-18 Ruby 4.5
2006-09-18 Ruby 4.5
2006-08-18 Ruby 4.5
2006-08-04 shq 8.0

If i select September then I should be able to see

Created At Product Price
2006-09-18 Ruby 4.5
2006-09-18 Ruby 4.5

So how to do that code?? please help me regarding this..

Thanks in advance
Harish

--
Posted via http://www.ruby-....

1 Answer

Simen

9/18/2006 1:40:00 PM

0

On 9/18/06, Naga harish Kanegolla <harish4groups@gmail.com> wrote:
> Hi,
> Could anybody please help me to search the record by date
>
> I have one products table. In that table I have created_at.I want to
> search the records by date.
>
> I mean, if i select month as january and year as 2006 then i want to get
> the list as per that month only.
> Ex:
> Created At Product Price
> 2006-09-18 Ruby 4.5
> 2006-09-18 Ruby 4.5
> 2006-08-18 Ruby 4.5
> 2006-08-04 shq 8.0
>
> If i select September then I should be able to see
>
> Created At Product Price
> 2006-09-18 Ruby 4.5
> 2006-09-18 Ruby 4.5
>
> So how to do that code?? please help me regarding this..
>
> Thanks in advance
> Harish
>
> --
> Posted via http://www.ruby-....
>
>

If this is ActiveRecord with Rails, which I'm assuming it is, then the
Rails mailing list will probably be able to help you better. If it's
another library, please specify.

--
- Simen