problem in sorting

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • radhika8421
    New Member
    • Jul 2006
    • 2

    problem in sorting

    hi friends ,

    i got a problem in sorting the numbers.Dataent ry people entered the value of the price fields as 12000 $12349 24,890..... in this format into the database price feild so i am not able to sort the price values into the dropdown menu box on the htmlpage.String tokenizer is not working in the jsp page.so please anybody can help me.
  • Niheel
    Recognized Expert Moderator Top Contributor
    • Jul 2005
    • 2432

    #2
    You could write code that would strip the dollar signs and commas out of the data and then maybe store the clean data in a temporary table or add a column to your current table called clean_prices
    niheel @ bytes

    Comment

    Working...