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:
Correct Owners & Permissions? (2000)
WebDNA 5.0 upgrade policies (2003)
If search results are blank... (2003)
Error 11 (1996)
Bug or syntax error on my part? (1997)
emailer stuck (1997)
Order file numbers different than the cart number. why? (2000)
Which GUI HTML editors work with WC ? (1997)
Problems with shopping cart (1997)
encrypt/decrypt (2001)
[WebDNA] Small Parsing Problem (2009)
FREE Web Server Monitor FREE (1997)
Turning a URL into a link (2003)
[searchString] (1997)
displaying 12 results 4 by 3 (2000)
Help name our technology! (1997)
Not really WebCat (1997)
Re:Running 2 two WebCatalog.acgi's (1996)
Change Subtotal (2000)
I give up!! (1997)