List of ruby keywords
1. alias
2. and
3. BEGIN
4. begin
5. break
6. case
7. class
8. def
9. defined
10. do
11. else
12. elsif
13. END
14. end
15. ensure
16. false
17. for
18. if
19. in
20. module
21. next
22. nil
23. not
24. or
25. redo
26. rescue
27. retry
28. return
29. self
30. super
31. then
32. true
33. undef
34. unless
35. until
36. when
37. while
38. yield
Monday, January 10, 2011
Sunday, January 9, 2011
SQL order_by "field" option
Hi all,
I tried to order the SQL results in a pre-defined order. Consider the case
Am having users table, and a field called 'status' to store the current status of the user.
In back-end of my site, am displaying all the users with order-by 'status'
Possible status values are "Pending", "Approved", "Canceled", "Deleted"
I need to display users in the following orders,
"Approved", "Pending", "Canceled", "Deleted"
The normal order by field orders the field in either ASC/DESC. But in this case it is different.
For this i used the following query to fetch SQL results in a defined order
Rails finder:
User.find_by_sql("select * from users order by field (status,'Approved', 'Pending', 'Canceled', 'Deleted')")
SQL query:
select * from users order by field (status,'Approved', 'Pending', 'Canceled', 'Deleted');
Result contains the collection in the defined order.
When you are using this "order by field" option, you have to give all the option in the order then only it will works.
Thanks,
Vadivelan
I tried to order the SQL results in a pre-defined order. Consider the case
Am having users table, and a field called 'status' to store the current status of the user.
In back-end of my site, am displaying all the users with order-by 'status'
Possible status values are "Pending", "Approved", "Canceled", "Deleted"
I need to display users in the following orders,
"Approved", "Pending", "Canceled", "Deleted"
The normal order by field orders the field in either ASC/DESC. But in this case it is different.
For this i used the following query to fetch SQL results in a defined order
Rails finder:
User.find_by_sql("select * from users order by field (status,'Approved', 'Pending', 'Canceled', 'Deleted')")
SQL query:
select * from users order by field (status,'Approved', 'Pending', 'Canceled', 'Deleted');
Result contains the collection in the defined order.
When you are using this "order by field" option, you have to give all the option in the order then only it will works.
Thanks,
Vadivelan
Subscribe to:
Posts (Atom)