Sorting on integer values showing phrases in particular cloumn

Sorting on integer values showing phrases in particular cloumn

jerryjerry Posts: 5Questions: 0Answers: 0
edited October 2009 in General
I have implemented datatable and is working great. Now I just want to do different type of sorting. I have integer values in my database and after getting these values I am changing these values to some phrases to show on table. Now When I do sorting, it sort on the basis of these phrases not on integer values that I have in DB that is technically correct. But, now I am wondering is it possible to show phrases in table but sort on the basis of integer values from database.

Thanks

Replies

  • jerryjerry Posts: 5Questions: 0Answers: 0
    Problem solved :)
  • ubunTuxubunTux Posts: 7Questions: 0Answers: 0
    How did you do it?
  • jerryjerry Posts: 5Questions: 0Answers: 0
    I simply append the integer values from the database in front of the phrases as hidden value (ex: 1(hidden)+somephrase), so that it shows just phrases on interface.
  • ubunTuxubunTux Posts: 7Questions: 0Answers: 0
    Nice! Thanks!



    .ubuntux
This discussion has been closed.