Charting records by state

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27211
interpreted = N
texte = I came up with the following routine to display a summary of database records by state. It works well, but I have a few questions. 1) It does a lot of searches. It runs fast now, but I am not sure how it will respond when the database grows. Is there a way to make it more efficent?2) When you run it and view page source, you see lots and lots of blank lines. They do not affect the display, but the speed? How do I get rid of them. 3) Is there a better way to make a chart? -Chuck- [math show=f]maxcols=10[/math][search db=Registry.db&statesumm=T&statesort=1&neSKUdata=not_found] [founditems] [search db=Registry.db&eqstatedata=[state]] [founditems][/founditems] [showif [numfound]>[maxcols]] [math show=f]maxcols=[numfound][/math] [/showif] [/search] [/founditems] [/search] [math show=f]maxcols=[maxcols]+1[/math]
[search db=Registry.db&statesumm=T&statesort=1&neSKUdata=not_found]
Hauntists by State [loop start=1&end=[maxcols]&advance=1] [/loop] [founditems] [/search] [/founditems]
StateCount[index]
[state] [search db=Registry.db&eqstatedata=[state]] [founditems][/founditems] [numfound]   
[/search]
__________________________________________________________________________ Chuck Rice ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re[4]: Charting records by state (jpeacock@univpress.com 2000)
  2. Re[3]: Charting records by state (Kenneth Grome 2000)
  3. Re[3]: Charting records by state (jpeacock@univpress.com 2000)
  4. Re[2]: Charting records by state (Kenneth Grome 2000)
  5. Re: Charting records by state (Kenneth Grome 2000)
  6. Re[2]: Charting records by state (Webcat 2000)
  7. Re[2]: Charting records by state (jpeacock@univpress.com 2000)
  8. Re: Charting records by state (John Butler 2000)
  9. Charting records by state (Chuck Rice 2000)
I came up with the following routine to display a summary of database records by state. It works well, but I have a few questions. 1) It does a lot of searches. It runs fast now, but I am not sure how it will respond when the database grows. Is there a way to make it more efficent?2) When you run it and view page source, you see lots and lots of blank lines. They do not affect the display, but the speed? How do I get rid of them. 3) Is there a better way to make a chart? -Chuck- [math show=f]maxcols=10[/math][search db=Registry.db&statesumm=T&statesort=1&neSKUdata=not_found] [founditems] [search db=Registry.db&eqstatedata=[state]] [founditems][/founditems] [showif [numfound]>[maxcols]] [math show=f]maxcols=[numfound][/math] [/showif] [/search] [/founditems] [/search] [math show=f]maxcols=[maxcols]+1[/math]
[search db=Registry.db&statesumm=T&statesort=1&neSKUdata=not_found]
Hauntists by State [loop start=1&end=[maxcols]&advance=1] [/loop] [founditems] [/search] [/founditems]
StateCount[index]
[state] [search db=Registry.db&eqstatedata=[state]] [founditems][/founditems] [numfound]   
[/search]
__________________________________________________________________________ Chuck Rice ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Chuck Rice

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:

Multiple Hideif peramiters (2001) Show items based on login Password (2003) [WebDNA] [thisurlplusget] and the correct use of (2013) Browser Info.txt -- newest additions? (1997) Windows nt service pack 3 upgrade (1997) Getting total number of items ordered (1997) RequiredFields template (1997) UPS QuickCost and More (2000) Prevent multiple appends with Reload Button (1997) [shownext] and descending order (1997) UPS Shipping (1999) RE: Fishing: anyone on this group willing to do support? (1998) PSC recommends what date format yr 2000??? (1997) Price recalc based on quantity (1997) # fields limited? (1997) Customer loyalty scheme (2005) Newbie questions (1999) WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) Converting characters to numbers ... (1997) Snake Bites (1997)