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:
2.0 Info (1997)
getchars broken? (1997)
select menus & database design (1998)
Running WebCat from a CD-ROM (1997)
WebDNA tables and commas (2004)
Blasted shownext (request for 4.0) (1998)
RE: E-mailer error codes (1997)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
WebCat b15 Mac plug-in (1997)
[founditems] & radiobuttons (2002)
emailer (1997)
New NT betas available (1997)
PCS Emailer's role ? (1997)
Multiple Users.db Possible? (1997)
WebCatalog can't find database (1997)
PSC recommends what date format yr 2000??? (1997)
WebCatalog for guestbook ? (1997)
Ship via options price (2000)
find with exceptions (1997)
list problems (digest) (1998)