Re: Sorting
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18228
interpreted = N
texte = >> >
> >HREF=/cgi-bin/items.tpl?command=search&db=../products.db&eqSTORE1datarq=golf&w>> >sTYPE1datarq=Books&eqPRONAMEdatarq=[url][PRONAME][/url]&cart=[cart]&searchPRONAM>> >E=[url][PRONAME][/url]&eqNEWITEMdata=YES&NEWITEMsort=1&NEWITEMsdir=as&max=150>>I have tried removing NEWITEMsort=1&NEWITEMsdir=as and my results still do not>appear as I would like them to. Ideally I would like to have all items that have>YES in the NEWITEM field to be returned alphabetically at the top of the list, then>all other items returned alphabetically at the bottom of the list this way the new>books are listed at the top of the page.What values other than YES will appear in the NEWITEM field? If no other values will appear in that field, just use deNEWITEMsort=1&asPRONAMEsort=2 as your sort parameters, and don't use any other sort parameters, then you'll get what you want ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>> >
> >HREF=/cgi-bin/items.tpl?command=search&db=../products.db&eqSTORE1datarq=golf&w>> >sTYPE1datarq=Books&eqPRONAMEdatarq=[url][PRONAME][/url]&cart=
[cart]&searchPRONAM>> >E=
[url][PRONAME][/url]&eqNEWITEMdata=YES&NEWITEMsort=1&NEWITEMsdir=as&max=150>>I have tried removing NEWITEMsort=1&NEWITEMsdir=as and my results still do not>appear as I would like them to. Ideally I would like to have all items that have>YES in the NEWITEM field to be returned alphabetically at the top of the list, then>all other items returned alphabetically at the bottom of the list this way the new>books are listed at the top of the page.What values other than YES will appear in the NEWITEM field? If no other values will appear in that field, just use deNEWITEMsort=1&asPRONAMEsort=2 as your sort parameters, and don't use any other sort parameters, then you'll get what you want ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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:
Type 11 errors setting up WebCAt 2 (1997)
[ot] ShowIf & HideIf Question (1998)
Help! WebCat2 bug (1997)
Re:Emailer and encryption (1997)
Shoppingcart passing price (2000)
Re1000001: Setting up shop (1997)
no global [username] or [password] displayed ... (1997)
Chat Area (2000)
DreamWeaver Extensions (2000)
Sorting Numbers (1997)
Date question (2003)
Removing [showif] makes a big difference in speed (1997)
[WebDNA] Function and surviving variables (2015)
FAX orders (1996)
Locking up with WebCatalog... (1997)
Pieces Show Up! Curse You! (2000)
Requiring that certain fields be completed (1997)
Shared databases (2003)
Upload and WebCat (1998)
question on [delete] (1998)