Re: Sorting Number with commas
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39667
interpreted = N
texte = Joseph Sullivan wrote:> > I must be doing something wrong here.> > How do i get number with commas in them to sort right?> > When I have numbers with commas in them, they sort funny.> > Any thing I am missing?Numbers don't have commas. If you want to sort them numerically, you must strip out the commas. Otherwise they are strings and will sort alphanumerically: 1,000,000 2,000 2,999,999John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Joseph Sullivan wrote:> > I must be doing something wrong here.> > How do i get number with commas in them to sort right?> > When I have numbers with commas in them, they sort funny.> > Any thing I am missing?Numbers don't have commas. If you want to sort them numerically, you must strip out the commas. Otherwise they are strings and will sort alphanumerically: 1,000,000 2,000 2,999,999John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Include error (2000)
WebCat2b12plugin - [search] is broken ... not! (1997)
[OT] What System Software? (2003)
SKU generator? (1998)
Running 2 two WebCatalog.acgi's (1996)
Developer Edition (2003)
Advice needed. (1998)
Bug Report, maybe (1997)
Email/Order to fax? (2003)
Updating a database once per day - An example (1998)
HomePage Caution (1997)
WebCommerce: Folder organization ? (1997)
Webcat/Webmerchant (1998)
WebCat, The Trend, & Consolidating... (1997)
Document Contains No Data, Blank Pages with b4, b6 mac! (1999)
Emailer again & again (1997)
Running _every_ page through WebCat ? (1997)
Netscape for MacOS X (2001)
Grouping fields problem (1998)