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=50 if you want to search and sort by sku replace the above with this http://www.novaderm.com/novastore/Search.tpl?command=search&db=catalog.txt&skuso rt=1&skusdir=as&neSKUdata=[blank] First you have to tell it the sort priority which is 1 and then the sdir or sort 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 base but if you want to limit it to onrecords that are t in categorysumm then replace 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:

    
  1. Re: Help with sorting search results sorting (Will Starck 1998)
  2. Re: Help with sorting search results sorting (Gary Richter 1998)
  3. Help with sorting search results sorting (Will Starck 1998)
>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=50 if you want to search and sort by sku replace the above with this http://www.novaderm.com/novastore/Search.tpl?command=search&db=catalog.txt&skuso rt=1&skusdir=as&neSKUdata=[blank] First you have to tell it the sort priority which is 1 and then the sdir or sort 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 base but if you want to limit it to onrecords that are t in categorysumm then replace 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)