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 othervalue of NewItem is A-X, or assuming it is NO, then sort on that field anddo a does not equal balnk of the same field. Then you will get all therecords sorted with YES first and then all the records below it as long asthe field is not blank. Or you could pick another field to do yourselction 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 othervalue of NewItem is A-X, or assuming it is NO, then sort on that field anddo a does not equal balnk of the same field. Then you will get all therecords sorted with YES first and then all the records below it as long asthe field is not blank. Or you could pick another field to do yourselction 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:
Colors in cart (2002)
Missing from Docs [folderName] (1997)
SpiderBotLock! (2003)
Paranoid about serial numbers...not (1998)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
ShowIf inside formulas (1997)
For those of you not on the WebCatalog Beta... (1997)
Help formatting search results w/ table (1997)
WebMerchant problems (2000)
[OT] Javasript Help (2006)
problems with 2 tags shakur (1997)
[WebDNA] Security best practice (2009)
New commands in Final candidate (1997)
RE: [WebDNA] XML Help (2009)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Sensations (1997)
Price override - solved (2004)
Logging purchases (1997)
[WebDNA] Can anyone share a markdown type text converter in WebDNA? (2011)
Grouping fields help (2004)