Re: Sorting a summary
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34140
interpreted = N
texte = I think you've got to build a temporary database and then sort that db on the count. Create an empty database named temp.db with two fields, TEMPSTATE and TEMPNUM. Then code your template something like this:[!] This deletes all the records from the previous hit of the database [/!][delete db=temp.db&neTEMPSTATEdata=__all__][search db=dbs/custinfo.db&geSTATEdata=0&STATEsumm=T][founditems] [searchdb=dbs/custinfo.db&eqSTATEdatarq=[STATE]&max=1] [founditems] [append db=temp.db]TEMPSTATE=[STATE]&TEMPNUM=[numfound][/append] [/founditems] [/search][/founditems][/search][search db=temp.db&neTEMPSTATEdata=__all__&deTEMPNUMsort=1&TEMPNUMtype=num] [founditems] [TEMPSTATE] [TEMPNUM] [/founditems][/search]One warning... if there is a possibility that more then one visitor will be hitting this template at the same time, then you need to create the temp database on the fly and use the [cart] variable in the name of the temp database to make it unique.___Joe____________________________________________________Joseph D'Andrea JoeDan@West21.comWEST21.com Internet services for the 21st Century http://www.west21.com/_________________________________________________-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I think you've got to build a temporary database and then sort that db on the count. Create an empty database named temp.db with two fields, TEMPSTATE and TEMPNUM. Then code your template something like this:[!] This deletes all the records from the previous hit of the database [/!][delete db=temp.db&neTEMPSTATEdata=__all__][search db=dbs/custinfo.db&geSTATEdata=0&STATEsumm=T][founditems] [searchdb=dbs/custinfo.db&eqSTATEdatarq=[STATE]&max=1] [founditems] [append db=temp.db]TEMPSTATE=[STATE]&TEMPNUM=[numfound][/append] [/founditems] [/search][/founditems][/search][search db=temp.db&neTEMPSTATEdata=__all__&deTEMPNUMsort=1&TEMPNUMtype=num] [founditems] [TEMPSTATE] [TEMPNUM] [/founditems][/search]One warning... if there is a possibility that more then one visitor will be hitting this template at the same time, then you need to create the temp database on the fly and use the [cart] variable in the name of the temp database to make it unique.___Joe____________________________________________________Joseph D'Andrea JoeDan@West21.comWEST21.com Internet services for the 21st Century http://www.west21.com/_________________________________________________-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Joseph D'Andrea
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:
Globals Problem and now can't close databases (2003)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
Emailer problem with WC 2.1, NT, WebSite 2.1 (1998)
Information on Vieworders.tpl (1998)
IE Cache Problems... (1999)
showif and cart (1997)
[math date] with non-US date format (2000)
Save Word/Excel Docs to Server (2002)
Whats wrong with this???? (2001)
NT or Mac (1998)
Help name our technology! (1997)
PIXO support (1997)
What file? (1997)
Another question (1997)
WebCat2 - [format thousands] (1997)
Calculating Shipping (1997)
WebCat2: Found Items syntax, etc. (1997)
[WebDNA] Range calculation w/negative values (2011)
[WebDNA] Sendmail Problems (2008)
Running _every_ page through WebCat ? (1997)