Sorting on a currency field? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

FPGuy -> Sorting on a currency field? (3/1/2001 17:16:00)

I followed the instructions to sort on different field via microsoft's link in spooky's advanced section. Things work great except I want to be able to sort by price and when I do the results are sorted like this
$1.32
$1.45
$15.23
$1.62 etc.

Anyways it appears to ignore the decimal. Anyone know whats up?

[This message has been edited by FPGuy (edited 03-01-2001).]




FPGuy -> RE: Sorting on a currency field? (3/2/2001 20:15:00)

Figured it out, I was sorting on a field that I was formatting in the query so it wouldn't truncate the price ie. $6.5 instead of $6.50. When I sort on the actual price field it works fine.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625