Re: Help with sorting search results sorting
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20239
interpreted = N
texte = >Hi all->>I need help with the display of search results. I've created a small store>(15 items) using the General Store templates. I've RTFM (woohoo!) and have>figured out how to sort the results in ascending order by SKU when I click>on Show all items in the catalog or one of the individual categories.>>OK, my problem is getting the results to sort by SKU when I try Expert>Search. Does this involve fiddling with the [founditems] context somehow,>or somewhere else?? I've tried altering the code on both Search.tpl and>Results.tpl without success.>>>TIA,>>Will Starck>
>+++++++++++++>>>>The relevant page may be found at> http://www.novaderm.com/novastore/Search.tpl?command=search&neSKUdata=[blan>k]&db=catalog.txt&categorysumm=t&ascategorysort=1&max=50if you want to search and sort by sku replace the above with thishttp://www.novaderm.com/novastore/Search.tpl?command=search&db=catalog.txt&skusort=1&skusdir=as&neSKUdata=[blank]First you have to tell it the sort priority which is 1 and then the sdir orsort direction which is as or asending.It is all covered in the online docs at/webcatalog/webcatreference/SearchSorting.htmlI have no idea what the field categorysumm=t relates to in your data basebut if you want to limit it to onrecords that are t in categorysumm thenreplace the &neSKUdata=[blank] with &categorysumm=tLet me know if this is what you where looking for.===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
Associated Messages, from the most recent to the oldest:
>Hi all->>I need help with the display of search results. I've created a small store>(15 items) using the General Store templates. I've RTFM (woohoo!) and have>figured out how to sort the results in ascending order by SKU when I click>on Show all items in the catalog or one of the individual categories.>>OK, my problem is getting the results to sort by SKU when I try Expert>Search. Does this involve fiddling with the [founditems] context somehow,>or somewhere else?? I've tried altering the code on both Search.tpl and>Results.tpl without success.>>>TIA,>>Will Starck>>+++++++++++++>>>>The relevant page may be found at> http://www.novaderm.com/novastore/Search.tpl?command=search&neSKUdata=[blan>k]&db=catalog.txt&categorysumm=t&ascategorysort=1&max=50if you want to search and sort by sku replace the above with thishttp://www.novaderm.com/novastore/Search.tpl?command=search&db=catalog.txt&skusort=1&skusdir=as&neSKUdata=[blank]First you have to tell it the sort priority which is 1 and then the sdir orsort direction which is as or asending.It is all covered in the online docs at/webcatalog/webcatreference/SearchSorting.htmlI have no idea what the field categorysumm=t relates to in your data basebut if you want to limit it to onrecords that are t in categorysumm thenreplace the &neSKUdata=[blank] with &categorysumm=tLet me know if this is what you where looking for.===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
Gary Richter
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:
OK, here goes... (1997)
Re:quit command on NT (1997)
RequiredFields notes ... (1997)
serial number generation (1997)
Now you see it now you donīt (1997)
[WebDNA] What does PHP(5) has, that Webdna hasn't (2009)
Exclamation point (1997)
Need relative path explanation (1997)
Signal Raised Error (1997)
New index for docs (1997)
Help formatting search results w/ table (1997)
CART question (2004)
zzounds.com. Was: ANN: Strategic Partnership with BuyStream Announced. (2000)
Configuring E-mail (1997)
hidden databases (2000)
[showif],[refferer],[include] in errormessages.db (2002)
Problem with updating 2.1b7 -> 2.1.1 (1998)
Location of Browser Info.txt file (1997)
Mac Vs WindowsNT (1997)
pop up menu's (1998)