> I have a find that look likes this:
>
> @values = UdidValue.find(:all,
> :conditions => [''udid_id = ?'', x.id], :order =>
''value ASC'')
>
> The problem is that ''value'' could be a street address,
for example,
> numbers. So, when I do the :order if they are strings the get order
> wonderfully, but in one case I have values that are numbers, for
> example, 234, 233, 219, 25, 199, which get order as 199, 25, 219, 233,
> 234. Which is not what I want. I would like to order as 25, 199, 219,
> 233, 234.
>
> Is there a way to get the order to order properly regardless if it
> is a
> number of string? Thanks,
Google for "natural sort" for your particular database.
If mysql, maybe...
http://blog.feedmarker.com/2006/02/01/how-to-do-natural-alpha-numeric-sort-in-mysql/
--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---