Re: Sorting problems
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32943
interpreted = N
texte = >When I do a search such and require the results to show sorted by price: > >[search >db=Entermerch.db&eqmajorCategorydatarq=[url][majorCategory][/url]&PRICEsort=1&PRICEsdir=as&max=12&AllHit=1&startat=[url][startat][/url]] > >[founditems] > >1,140 116 127 1,274 1,658 1,659 195 250 > >[/founditems] > >It seems to take only the first 3 digits into consideration? Okay, first of all you're not telling webcat to sort numerically, because your search context doesn't have a PRICEtype=num parameter in it. Please read the HTML docs under Searching to learn how to define a field type with parameters like this ...Also, your PRICE values have commas in them, so they are not properly formatted as numbers -- which means webcat won't be able to sort them numerically even after you add the above parameter.The *only* valid characters in a number are digits and a dot -- that's all. Therefore, you must add the parameter above as well as get rid of the commas, before you will be able to sort numerically and get the results you want ... :) ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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:
>When I do a search such and require the results to show sorted by price: > >[search >db=Entermerch.db&eqmajorCategorydatarq=[url][majorCategory][/url]&PRICEsort=1&PRICEsdir=as&max=12&AllHit=1&startat=[url][startat][/url]] > >[founditems] > >1,140 116 127 1,274 1,658 1,659 195 250 > >[/founditems] > >It seems to take only the first 3 digits into consideration? Okay, first of all you're not telling webcat to sort numerically, because your search context doesn't have a PRICEtype=num parameter in it. Please read the HTML docs under Searching to learn how to define a field type with parameters like this ...Also, your PRICE values have commas in them, so they are not properly formatted as numbers -- which means webcat won't be able to sort them numerically even after you add the above parameter.The *only* valid characters in a number are digits and a dot -- that's all. Therefore, you must add the parameter above as well as get rid of the commas, before you will be able to sort numerically and get the results you want ... :) ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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/
Kenneth Grome
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:
OT (stupid redirect/refresh question) (2002)
Copyright ? (1997)
Passing radio check box value to itself... (2000)
different show next (1997)
Does [Sendmail] create html? (2002)
[WriteFile] problems (1997)
Sort Order on a page search (1997)
WebCatalog can't find database (1997)
Possible Bug in 2.0b15.acgi (1997)
[WebDNA] ImageMagick (2009)
Where is f2? (1997)
Opinion: [input] should be called [output] ... (1997)
Re:Signal Raised (1997)
[SearchString] problem with [search] context (1997)
Authorize.net SIM/AIM deadline extended (2003)
[WebDNA] Sending 100 mails an hour then pausing (2010)
Date Formats (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Bad URL reference? (1997)
Limit on nested [ShowIf]'s? (1997)