Rails - Dec 2005 - Just another syntax question

Drag list order

I have an ''each do'' loop iterating through the results 
of an ''ordered''  ''DB.find'' . It appears that
regardless of
the order of the ''find'', the ''each do'' loop
serves it up and
displays in the order of  the ''DB.id'' ie id
''1'' first ''id'' 2 second etc.

However I wish the order as viewed to not be in the order
 of the ''id'' field but in the order of another field in the DB
which is changed by the drag action.
 ie each do by some other field than id

Cant quite get a handle on the syntax - 
some variation of the each do or something else entirely
or am I missing the bleedin obvious

Try adding something like

	:order => "column_name DESC"

to your find as in
	
	DB.find(:all, :order => "column_name DESC")

where column_name is the column you wish to order by.  DESC can also  
be ASC I assume.





On Dec 17, 2005, at 2:30 PM, Geoff wrote:
> Drag list order
>
> I have an ''each do'' loop iterating through the results
> of an ''ordered''  ''DB.find'' . It appears
that regardless of
> the order of the ''find'', the ''each do''
loop serves it up and
> displays in the order of  the ''DB.id'' ie id
''1'' first ''id'' 2 second
> etc.
>
> However I wish the order as viewed to not be in the order
>  of the ''id'' field but in the order of another field in
the DB
> which is changed by the drag action.
>  ie each do by some other field than id
>
> Cant quite get a handle on the syntax -
> some variation of the each do or something else entirely
> or am I missing the bleedin obvious
>
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails


_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails