Re: fieldsumm quandary

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37845
interpreted = N
texte = From the online docs:ZipCodesumm=T tells WebCatalog that if one or more zip code are identical, they are removed from the list of found items. Only the first matching ZipCode record is displayed.- brianAt 7:37 PM 8/14/2001, Will Starck wrote: >When I add emailsumm=T to a search, how does WebCatalog handle this exactly? > >The reason I ask is the following: > >I have a database, orders.db, which contains all of the info regarding each >order placed. In the normal course of things, when I want to advertise a >sale, a run a search on this db, like so: > >[search db=orders.db&neemaildata=[blank]&emailsumm=T] >[founditems] >[sendmail...] > >Of course the emailsumm=T ensures that only one email is sent per customer. > >Now, suppose I run a sale. Customer A, whose name is already recorded in >orders.db, orders again. So, now she has two records in orders.db. Two weeks >later, I want to send out another email advertisement of the sale, but I >*don't* want anyone who has already ordered during the sale to get an email. > >So, my search can change to: > >[search db=orders.db&neemaildata=[blank]&emailsumm=T] >[founditems] >[hideif [orderdate]>08/01/2001] >[sendmail...] > >But, I don't know which [email] in the db the fieldsumm chooses. Is it the >first one it encounters? Or, does WebCat somehow write the summed emails to >a buffer and then spit one out when it's done reading the whole db? > >If I know exactly how summing works, I can arrange my search to find the >sale records first or last, so that the emails will be sent correctly... > >Will Starck >NovaDerm >skin care science >http://www.novaderm.com >-techs@novaderm.com >800-378-1740 >800-378-1740------------------------------------------------------------- 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: fieldsumm quandary (Brian Fries 2001)
  2. fieldsumm quandary (Will Starck 2001)
From the online docs:ZipCodesumm=T tells WebCatalog that if one or more zip code are identical, they are removed from the list of found items. Only the first matching ZipCode record is displayed.- brianAt 7:37 PM 8/14/2001, Will Starck wrote: >When I add emailsumm=T to a search, how does WebCatalog handle this exactly? > >The reason I ask is the following: > >I have a database, orders.db, which contains all of the info regarding each >order placed. In the normal course of things, when I want to advertise a >sale, a run a search on this db, like so: > >[search db=orders.db&neemaildata=[blank]&emailsumm=T] >[founditems] >[sendmail...] > >Of course the emailsumm=T ensures that only one email is sent per customer. > >Now, suppose I run a sale. Customer A, whose name is already recorded in >orders.db, orders again. So, now she has two records in orders.db. Two weeks >later, I want to send out another email advertisement of the sale, but I >*don't* want anyone who has already ordered during the sale to get an email. > >So, my search can change to: > >[search db=orders.db&neemaildata=[blank]&emailsumm=T] >[founditems] >[hideif [orderdate]>08/01/2001] >[sendmail...] > >But, I don't know which [email] in the db the fieldsumm chooses. Is it the >first one it encounters? Or, does WebCat somehow write the summed emails to >a buffer and then spit one out when it's done reading the whole db? > >If I know exactly how summing works, I can arrange my search to find the >sale records first or last, so that the emails will be sent correctly... > >Will Starck >NovaDerm >skin care science >http://www.novaderm.com >-techs@novaderm.com >800-378-1740 >800-378-1740------------------------------------------------------------- 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/ Brian Fries

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:

Web Catalog vs. ICAT (1997) RE: Answer: WebDelivery downloads alias, not original ? (1997) Cold Fusion Warm and Fuzzy? (1999) How to Sort Summ data ? (1997) access denied problem (1997) Date Calulation (1997) ACGI processing for .html (1997) Custom Shipping Charges (1997) [ShowNext] feature in 2.0 (1997) page redirect in webDNA (1997) Date Range search (1997) WebCat2b15MacPlugin - showing [math] (1997) default value from Lookup (1997) email address with spaces (2001) PCS Customer submissions ? (1997) Re:Copyright ? (1997) Mac: LModelDirector bug fix (1997) DDE feature in webcat (1998) [Webcat 2]Next (1997) help with duplicate records posted (1998)