On May 20, 1:06 pm, Eric <[email protected]> wrote:
> :lower[ :l_name ]   works just right.
>
> Thanks, one less nit off my checklist.

Note that that doesn't work in Ruby 1.9, since ruby defines Symbol#
[].  Here's a better way:

  Emp.select(:id, (:f_name.sql_string + :l_name).as(:name)).
   order{[lower(l_name), lower(f_name)]}.all

You need to be using Sequel 3.0 for that code to work.

Jeremy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sequel-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/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to