Gossamer Forum
Home : Products : DBMan : Customization :

Problem with sorting

Quote Reply
Problem with sorting
I have problems sorting my records probably. Here is the case:

I have a field named 'Price' and a field named 'Tax'. The price field contains numbers while the tax field contains either 'within' and 'without'. Then when I'm displaying my records DBman automatically corrects the prices without taxes, so that all prices includes taxes. And here is the problem: When I'm sorting by price, the results are naturally sorted by the numbers in the price field in the db, and not the numbers displayed to the user. So what I would like to do, is having the numbers corrected somewhere in the display process, so that the result will be that the records are sorted by the numbers displayed.

I really need help with this one!

Regards,

Alex
Subject Author Views Date
Thread Problem with sorting AlexVB 1738 Aug 27, 2002, 8:54 AM
Post Re: [AlexVB] Problem with sorting
Lex 1675 Aug 28, 2002, 10:37 AM