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:

WCS Newbie question (1997) WebCatalog for guestbook ? (1997) Problems with [Applescript] (1997) database size? (1997) Search Combining Problem (2004) restarting service remotely on NT (1997) [WebDNA] special chars (2009) New to WebCat, Help. (1998) [WebDNA] Can WebDNA corrupt a db? (2012) WebCat for Unix?? (1997) Nesting WebDNA in JavaScript (2003) Browser Info.txt (1997) frames & carts (1997) Encyption mail was Suggestions for Topics ... (1998) webcat- multiple selection in input field (1997) E-Mail Preferences in Admin Folder (1997) Multiple cart additions (1997) can we get string variables? (1998) Navigator 4.01 (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997)