Re: Sorting a Search...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18316
interpreted = N
texte = >
href=search.tmpl$search?geSKUdata=0&db=catalog.txt&categorysumm=t&AllHit=1 >>Search by Category > >What I get seems to be a random ordering of the categories. They aren't >even sorted by best of sorting. I have tried every variation I can >think of after reading the manual, including adding sdir commands, etc. >No luck, and no change in the ordering of the categories at all... Hi Timothy,Make sure to open the HTML documentation for WebCatalog and leave it open in a new browser window when you're working on your WebDNA code. The best page I've found for quick reference is the one at:WebCatalog/WebCatReference/MajorGroups.htmlThis is the Major Groups page, and it has a link to every tag in the WebDNA language. For this situation, the link you need is the Searching link, then the sorting link.As far as your sorting problems are concerned, you don't have any sort parameters in your search string, that's why WebCat's not sorting your results. Try this instead:search.tmpl?command=search&db=catalog.txt&neSKUdatarq=[blank]&categorysumm=T&ascategorysort=1This will sort in ascending order on the category field. Ascending means alphabetically when you're sorting a text field, and all WebCat fields are considered to be text fields unless you add parameters to tell WebCat they are number or date fields instead ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>
href=search.tmpl$search?geSKUdata=0&db=catalog.txt&categorysumm=t&AllHit=1 >>Search by Category > >What I get seems to be a random ordering of the categories. They aren't >even sorted by best of sorting. I have tried every variation I can >think of after reading the manual, including adding sdir commands, etc. >No luck, and no change in the ordering of the categories at all... Hi Timothy,Make sure to open the HTML documentation for WebCatalog and leave it open in a new browser window when you're working on your WebDNA code. The best page I've found for quick reference is the one at:WebCatalog/WebCatReference/MajorGroups.htmlThis is the Major Groups page, and it has a link to every tag in the WebDNA language. For this situation, the link you need is the Searching link, then the sorting link.As far as your sorting problems are concerned, you don't have any sort parameters in your search string, that's why WebCat's not sorting your results. Try this instead:search.tmpl?command=search&db=catalog.txt&neSKUdatarq=[blank]&categorysumm=T&ascategorysort=1This will sort in ascending order on the category field. Ascending means alphabetically when you're sorting a text field, and all WebCat fields are considered to be text fields unless you add parameters to tell WebCat they are number or date fields instead ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
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:
Problems getting parameters passed into email. (1997)
multiple search commands (1997)
About that math question ... (2003)
Too Much Rootbeer Free Offer (1997)
Digest Version (2000)
Pretty Easy I bet (2000)
Encyption mail (1998)
[SHOWNEXT] Examples (1997)
Major bug report on rootbeer (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Serial Numbers (2000)
[WriteFile] problems (1997)
writing checkboxes to a database (2000)
Emailer Set Up (1997)
UPS (2003)
E-Commerce site for Canadian and US customers (1998)
Cart Question (1998)
Superfilous Characters (1998)
Setting up shop (1997)
Summing a field full of numbers ... (1997)