Re[2]: Charting records by state

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27221
interpreted = N
texte = Actually, I suggested that WebCat strip all CR/LF except when expressly told not to, with a system option to turn this on. The only time you really need to preserve CR/LF is inside [sendmail], [writefile], and possibly [returnraw]. All other times, the browser will filter out the extra whitespace anyways, but it does make the page bigger, and look weird in view source.I like to use lots of white space to make my files easier to read, but the browser will render an entire page without any CR/LF (except for the
 tag). I would appreciate it if I didn't have to increase the noise level of my codewith [!][/!]'s all over the place...John Peacock____________________Reply Separator____________________Subject:    Re: Charting records by state Author:  (WebCatalog Talk)Date:       2/8/00 11:49 AMI am not commenting on the speed of your code, butyou get rid of white space in the HTML by wrapping the carriage returns with the[!]context.like so-code....[!]¬[/!]....more code....[!]¬[/!]....more code...[!]¬[/!]etc.Would be nice to have a new context in 4.0 that just did all that automagically-[noWhite]codemore codemore code[/noWhite]-JohnChuck Rice wrote:> 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 ------------------------------------------------------------- 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[2]: Charting records by state (jpeacock@univpress.com 2000)
Actually, I suggested that WebCat strip all CR/LF except when expressly told not to, with a system option to turn this on. The only time you really need to preserve CR/LF is inside [sendmail], [writefile], and possibly [returnraw]. All other times, the browser will filter out the extra whitespace anyways, but it does make the page bigger, and look weird in view source.I like to use lots of white space to make my files easier to read, but the browser will render an entire page without any CR/LF (except for the
 tag). I would appreciate it if I didn't have to increase the noise level of my codewith [!][/!]'s all over the place...John Peacock____________________Reply Separator____________________Subject:    Re: Charting records by state Author:  (WebCatalog Talk)Date:       2/8/00 11:49 AMI am not commenting on the speed of your code, butyou get rid of white space in the HTML by wrapping the carriage returns with the[!]context.like so-code....[!]¬[/!]....more code....[!]¬[/!]....more code...[!]¬[/!]etc.Would be nice to have a new context in 4.0 that just did all that automagically-[noWhite]codemore codemore code[/noWhite]-JohnChuck Rice wrote:> 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 ------------------------------------------------------------- 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 jpeacock@univpress.com

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:

Cookies? (1997) two unique banners on one page (1997) WC2.0 Memory Requirements (1997) # fields limited? (1997) Searchable list mail via wwebcat (1998) Triggers (2003) virtual virtual hosted store.... (1998) Re1000001: Setting up shop (1997) Redirect (2003) Setting up shop (1997) [LINEITEMS] (2000) en/decrypt problem (1999) problem: mail changed (1997) flash-wc (2000) WebDelivery downloads alias, not original ? (1997) Credit card types (1997) Need help with text area (1998) Just Testing (1997) HomePage Caution (1997) Sorting error (1997)