Re: won't [sendmail] inside of a [search]

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69282
interpreted = N
texte = The only thing that occurs to me is the extra [/showif] inside the [sendmail][/sendmail] context.. - chris On Sep 14, 2007, at 11:16, sbraun1@twcny.rr.com wrote: > Hi All, > > I've run into a problem where WebDNA won't execute a [sendmail] > command inside of a > [search] process. > > Specifically, I have a .db of upcoming events to produce, and I use > a daily trigger to run a > [search] command to > find the next event(s). > Then I use a [showif] to test for the upcoming date that I want. > This works fine. > Then I use a [sendmail] to e-mail myself the data I need to remind > me of the upcoming > event. > The [sendmail] won't execute. > In fact if I view the code in a web browser when it is not working, > it looks like this: endmail > to=me@myemail.org&...etc...etc > The "[s" characters are missing. > > The [sendmail] works when I move it outside of the [search], but > that sends me an e-mail > each day, whether > there is an upcoming event found in the .db or not. > > Can anyone come up with a work-around on how to solve this problem? > Thanks in advance. > sfb > > > > > Here is my code: > > [search db=../ > reservations0708.db&geSKUdata=1&neLIVEdatarq=No&geFORMATTED_DATEdata=[ > date] > &asFORMATTED_DATEsort=1&FORMATTED_DATEtype=date&][founditems] > [showif [newvar]=[FORMATTED_DATE]] > > [sendmail > to=me@myemail.org&from=Theatre@www.oswego.org&subject=Performance > Reminder from Theatre > web page on [date] [TIME format=%I:%M:%S]&Content-Type=text/html] > > Event Reservation Database > >
This is an automated e-mail reminder of upcoming events > > [include the data I want about the upcoming event] [/showif] > > [/sendmail] > [/showif] > [/founditems] > [/search] > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: won't [sendmail] inside of a [search] ( sbraun1@twcny.rr.com 2007)
  2. Re: won't [sendmail] inside of a [search] ( Matthew A Perosi 2007)
  3. Re: won't [sendmail] inside of a [search] ( Chris 2007)
  4. won't [sendmail] inside of a [search] ( sbraun1@twcny.rr.com 2007)
The only thing that occurs to me is the extra [/showif] inside the [sendmail][/sendmail] context.. - chris On Sep 14, 2007, at 11:16, sbraun1@twcny.rr.com wrote: > Hi All, > > I've run into a problem where WebDNA won't execute a [sendmail] > command inside of a > [search] process. > > Specifically, I have a .db of upcoming events to produce, and I use > a daily trigger to run a > [search] command to > find the next event(s). > Then I use a [showif] to test for the upcoming date that I want. > This works fine. > Then I use a [sendmail] to e-mail myself the data I need to remind > me of the upcoming > event. > The [sendmail] won't execute. > In fact if I view the code in a web browser when it is not working, > it looks like this: endmail > to=me@myemail.org&...etc...etc > The "[s" characters are missing. > > The [sendmail] works when I move it outside of the [search], but > that sends me an e-mail > each day, whether > there is an upcoming event found in the .db or not. > > Can anyone come up with a work-around on how to solve this problem? > Thanks in advance. > sfb > > > > > Here is my code: > > [search db=../ > reservations0708.db&geSKUdata=1&neLIVEdatarq=No&geFORMATTED_DATEdata=[ > date] > &asFORMATTED_DATEsort=1&FORMATTED_DATEtype=date&][founditems] > [showif [newvar]=[FORMATTED_DATE]] > > [sendmail > to=me@myemail.org&from=Theatre@www.oswego.org&subject=Performance > Reminder from Theatre > web page on [date] [TIME format=%I:%M:%S]&Content-Type=text/html] > > Event Reservation Database > >
This is an automated e-mail reminder of upcoming events > > [include the data I want about the upcoming event] [/showif] > > [/sendmail] > [/showif] > [/founditems] > [/search] > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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://webdna.smithmicro.com/ Christophe Billiottet

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:

Summing fields (1997) Signal Raised Error (Part III) (1997) simple forum/bboard (2004) test (2003) ShowIf helper? (1998) WebCatalog Upgrade Pricing? (1997) Weird Math and SV (1997) Location of Browser Info.txt file (1997) [OT] Double chars in form (ie 5.2 mac OSX) (2004) Still Learning (1997) Still refusing connections ... (1999) Triggers (2001) Virtual hosting and webcatNT (1997) Subtotal Not Calculated on Invoice.html (1998) WebCat2 beta FTP site (1997) Re:appending to the database (1999) show all problem (1997) Extended [ConvertChars] (1997) emailer settings and control questions (1997) [isfile] ? (1997)