Re: Sorting
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18207
interpreted = N
texte = >I am trying to return a search in a specific order. Within the context >of a hyperlink I would like to have all items that have the value YES >in the NEWITEM field of a database listed at the top of the founditems, >then all others that meet the search criteria would follow. I have >tried the following syntax with no luck: > >
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 > >target=body>[PRONAME] > >I realize this should be pretty simply, but I am kinda new to this. >Any suggestions would be greatly appreciated.what you are doing is making them must eq=equal yes. If the only other value of NewItem is A-X, or assuming it is NO, then sort on that field and do a does not equal balnk of the same field. Then you will get all the records sorted with YES first and then all the records below it as long as the field is not blank. Or you could pick another field to do your selction on and only sort on newitems =============================================== 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:
>I am trying to return a search in a specific order. Within the context >of a hyperlink I would like to have all items that have the value YES >in the NEWITEM field of a database listed at the top of the founditems, >then all others that meet the search criteria would follow. I have >tried the following syntax with no luck: > >
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 > >target=body>[PRONAME] > >I realize this should be pretty simply, but I am kinda new to this. >Any suggestions would be greatly appreciated.what you are doing is making them must eq=equal yes. If the only other value of NewItem is A-X, or assuming it is NO, then sort on that field and do a does not equal balnk of the same field. Then you will get all the records sorted with YES first and then all the records below it as long as the field is not blank. Or you could pick another field to do your selction on and only sort on newitems =============================================== 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:
problems with WebCat-Plugin ()
Summing fields (1997)
PCS Emailer's role ? (1997)
off topic