Re: Date search and sendmail

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13753
interpreted = N
texte = >I was wondering if there was a way to a search of a db for specific >appended date and then do a mass mailing to email addresses relative to the >found dates.Hi Kevin,Yes, WebCat can do this!Here's a solution that will do exactly what you need, provided you use the default MM/DD/YYYY date format to store your dates in the database. I have no idea if my WebDNA code will work with your custom date format because I store my dates in the default format, but you can try it and see what happens: 1- Create a new text file called 'LastSentDate' and type the name Ken into it, then save it and put it in the same folder as your Home Page.2- Put this WebDNA code into your Home Page:[hideif [date]=[include LastSentDate]] [search db=XXX.db&eqdatedata=[math date]{[date]}-30[/math]] [founditems] [sendmail to=[email]&from=YYY&subject=ZZZ] Hey, this is your reminder message! [/sendmail] [/founditems] [/search] [writefile LastSentDate][date][/writefile] [/hideif]3- If your Home Page does *not* get requested at least once a day by your visitors, you will have to request it yourself. The above WebDNA only works when someone requests the page it's in.Isn't WebCatalog awesome? :)Sincerely, Ken Grome WebDNA Solutions 808-737-6499 http://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

    
  1. Re: Date search and sendmail (Grant Hulbert 1997)
  2. Re: Date search and sendmail (Kenneth Grome 1997)
  3. Date search and sendmail (Kevin Furuta 1997)
>I was wondering if there was a way to a search of a db for specific >appended date and then do a mass mailing to email addresses relative to the >found dates.Hi Kevin,Yes, WebCat can do this!Here's a solution that will do exactly what you need, provided you use the default MM/DD/YYYY date format to store your dates in the database. I have no idea if my WebDNA code will work with your custom date format because I store my dates in the default format, but you can try it and see what happens: 1- Create a new text file called 'LastSentDate' and type the name Ken into it, then save it and put it in the same folder as your Home Page.2- Put this WebDNA code into your Home Page:[hideif [date]=[include LastSentDate]] [search db=XXX.db&eqdatedata=[math date]{[date]}-30[/math]] [founditems] [sendmail to=[email]&from=YYY&subject=ZZZ] Hey, this is your reminder message! [/sendmail] [/founditems] [/search] [writefile LastSentDate][date][/writefile] [/hideif]3- If your Home Page does *not* get requested at least once a day by your visitors, you will have to request it yourself. The above WebDNA only works when someone requests the page it's in.Isn't WebCatalog awesome? :)Sincerely, Ken Grome WebDNA Solutions 808-737-6499 http://www.hui.net/dna/webdna.html Kenneth Grome

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:

Item options w/ price adjustment (1997) WebCat NT v. Mac (1997) problems with 2 tags shakur (1997) Protect and Serve (1999) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) 4.5.1 download link (2003) Email within tmpl ? (1997) WebCommerce: Folder organization ? (1997) Forcing a NEWCART (1997) can WC render sites out? (1997) shipCost not working v2.1b4 (1997) Updating Prices in Online Database (1999) formatting dates from a field ... (1997) help with duplicate records posted (1998) Remote stockroom ? (1998) F3 crashing server (1997) Emailer and encryption (1997) Major bug report on rootbeer (1997) Error Log.db --however (1997) [/application] error? (1997)