Hello!
I have a problem building a SQL query with sequel.
This is the query I want to get:
select "ID", "NAME", "CITY" from "USER" where lower("EMAIL") =
'mailaddress' or lower("NAME") like 'i%' or lower("CITY") like 'l%';
That's what I have so far, but I get an error "odd number list for
Hash (SyntaxError)"
users = DB[:USER].select(:ID, :NAME, :CITY).filter({:EMAIL => "mail"}
| {:NAME.like("i%")} | {:CITY.like("l%")})
Also I did not find how to set the columns to lower case.
Does anyone have an idea?
Thanks a lot in advance & Regards.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
