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:
Problem with [CART] number (1998)
WebMerchant and AVS (1998)
PSC recommends what date format yr 2000??? (1997)
Public beta 3 of WebCatalog 4.0 is now available (2000)
Virtual hosting and webcatNT (1997)
Exclamation point (1997)
[protect] on NT? (1997)
Sort Order on a page search (1997)
[WebDNA] Strange error (2014)
Here's how to kill a Butler Database. (1997)
Bug Report, maybe (1997)
OT Hosting Q again. (2002)
'Carting' into Frames (2000)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
RE: ShowNext Command (1997)
multi-part email help (2001)
showif with math? (2000)
[WebDNA] v7 Stress Test and Strange Behaviour (2012)
listfiles-looking for slick solution (1997)
I give up!! (1997)