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] [search db=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.com WEST21.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:

    
  1. Re: Sorting a summary (Joseph D'Andrea 2000)
  2. Sorting a summary (Jeff Grady 2000)
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] [search db=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.com WEST21.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:

& not allowed in db by definition? (1999) NT beta ReadMe missing (b12-b15) (1997) Search/sort in URL Was: GuestBook example (1997) Follow-up to listfiles bug report ... (2003) Re[2]: Support suggestions - Response (2000) Is there a max number of fields? (1998) Non HTML file protection - OS X (webstar or apache) (2002) sendmail and CGatePro - Not working (2003) SETCOOKIE Tricks (2003) removing programming logic white space (2003) Weird bug, or is there something amiss? (1997) Banner DNA (1997) international time (1997) New Plug-in and Type 11 errors (1997) Rumpus/Typhoon modules included in Typhoon ... (1997) [SHOWIF] PROBLEM (2000) Passing info in [Addlineitem] (1997) vs (1997) WebDNA for Window 2000 Server (2003) Pulldown Menu Problem (2000)