Hemant Bhargava wrote:
> I am executing an sql query .. as like ..
> abcarray = Abc.find(:all, :conditions => { :id => 'whatever', :name =>
> "Hemant" },:order => 'date, time' ) > abcarray records are in this format:- > id: 1, created_at: nil, updated_at: nil, day: 1, clinic_id: 13, time: > 530 > > abcarray consists of two fields day and time actually .. so i want to > sort them using date first and then time second .. > > Is dere any way to do it .. ? Now the lecture. Using ActiveRecord requires knowing SQL, even if AR does a very good job of hiding its verbosity. At the simplest extreme, AR find() often allows you to write the same kind of command, such as :group or :order, in the same way as the matching SQL GROUP BY or ORDER BY clause. Next, a :datetime field holds both the date and time together, so you ought to edit your model's migration and run rake db:migrate:reset to erase all your data and put those two fields together! -- Phlip --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---

