navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Sorting on a currency field?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Sorting on a currency field?
Page: [1]
 
FPGuy

 

Posts: 13
From: None
Status: offline

 
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

 

Posts: 13
From: None
Status: offline

 
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.

(in reply to FPGuy)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Sorting on a currency field?
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts