Re: Sort Floating Point Number
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 69717
interpreted = N
texte = This simple search gives the proper results for me: [search db=floatnum.db&neSKUdatarq=[blank]&gefloatnumdatarq=80.99&floatnumtype=num] FOUND: [numfound]
[founditems] [floatnum]
[/founditems] [/search] The database: SKU FLOATNUM 1 80.99 2 123.45 3 345.23 4 12.34 5 98.45 6 78.65 7 77.12 8 456.32 9 432.89 The results: FOUND: 6 98.45 456.32 123.45 80.99 345.23 432.89 So perhaps you have something else going on in your search string (searching the same field twice when sorting AND searching for ge 80.99 perhaps)? G. At 04:09 PM 1/29/2008, you wrote: Is it possible to sort a floating point number? We're trying to sort a search of product prices. For example, we want to bring up a list of all products that have prices greater than $80.99. Even though I did fieldnametype=num, it looks like it only works on integers. --------- Regards, Ki Song ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
This simple search gives the proper results for me: [search db=floatnum.db&neSKUdatarq=[blank]&gefloatnumdatarq=80.99&floatnumtype=num] FOUND: [numfound]
[founditems] [floatnum]
[/founditems] [/search] The database: SKU FLOATNUM 1 80.99 2 123.45 3 345.23 4 12.34 5 98.45 6 78.65 7 77.12 8 456.32 9 432.89 The results: FOUND: 6 98.45 456.32 123.45 80.99 345.23 432.89 So perhaps you have something else going on in your search string (searching the same field twice when sorting AND searching for ge 80.99 perhaps)? G. At 04:09 PM 1/29/2008, you wrote: Is it possible to sort a floating point number? We're trying to sort a search of product prices. For example, we want to bring up a list of all products that have prices greater than $80.99. Even though I did fieldnametype=num, it looks like it only works on integers. --------- Regards, Ki Song ------------------------------------------------------------- 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://webdna.smithmicro.com/
"Gary Krockover"
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:
Not really WebCat (1997)
Projects & Contractors (1997)
[BULK] [WebDNA] Snow Leopard Server install problems (2010)
Help formatting search results w/ table (1997)
WebDNA 4.5.1 Now Available (2003)
Weird problems with [SHOWIF]s (1997)
Re:listfiles-looking for slick solution (1997)
more on quicktime test stuff (1997)
WebCat2 several catalogs? (1997)
[math] storage of variables (1997)
Clean Code: Rules for inserting keyboard returns? (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
How true is this? (1999)
Web Catalog 2 demo (1997)
Founditems context returning only 1 item (1997)
YACBQ.....(Yet another checkbox question) (2000)
[IpAddress] Tag (1997)
WCS Newbie question (1997)
Mac 3.0.5b11 PI -- template cache and aliases (1999)
Sorting error (1997)