Re: Sort Floating Point Number

This WebDNA talk-list message is from

2008

It keeps the original formatting. numero = 69718
interpreted = N
texte = This worked for me:[search db=floatnum.db&geFLOATNUMdatarq=80.99&asFLOATNUMsort=1&FLOATNUMtype=num]FOUND: [numfound]

[founditems] [floatnum]
[/founditems][/search]RESULTS:-------------FOUND: 680.9998.45123.45345.23432.89456.32-DanOn Tue, 29 Jan 2008 17:09:03 -0500 Ki Song 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/-------------------------------------------------------------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:

Re: Sort Floating Point Number ( "Dan Strong" 2008) Re: Sort Floating Point Number ( "Gary Krockover" 2008) Re: Sort Floating Point Number ( Ki Song 2008) Re: Sort Floating Point Number ( Ki Song 2008) Re: Sort Floating Point Number ( Stuart Tremain 2008) Re: Sort Floating Point Number ( "Dan Strong" 2008) Sort Floating Point Number ( Ki Song 2008)

This worked for me:[search db=floatnum.db&geFLOATNUMdatarq=80.99&asFLOATNUMsort=1&FLOATNUMtype=num]FOUND: [numfound]

[founditems] [floatnum]
[/founditems][/search]RESULTS:-------------FOUND: 680.9998.45123.45345.23432.89456.32-DanOn Tue, 29 Jan 2008 17:09:03 -0500 Ki Song 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/-------------------------------------------------------------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/ "Dan Strong"

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:

Instructions for Digest (1997) Webcatalog 4.0 - When will we be able to beta test it? (2000) [protect admin] (1997) math a various prices (1997) Max Record length restated as maybe bug (1997) [WebDNA] [OT] Need to add second SSL host - what are my options? (2010) WebCat2.0 [format thousands .0f] no go (1997) taxrate - off by 1 cent (1997) WebCat2b15MacPlugin - [protect] (1997) How do I get multiple unique numbers on one template? (2000) available times? (2003) security (1997) E-mailer error codes (1997) WebCat for Site Search? (1997) Multiple radio buttons (1998) Problems appending to database (1997) Remove WebDNA context (2001) (2001) WebCatalog for Postcards ? (1997) Can I do these? (1997)