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

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69281
interpreted = N
texte = 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 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)
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 Web Archive of this list is at: http://webdna.smithmicro.com/ sbraun1@twcny.rr.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:

More questions about serial number dishing (1997) [decrypt seed=seed][getchars (1999) disappearing SKU (etc.) fields (1998) Tab Charactor (1997) Up and running ... at last !! (1997) Lost Records in Database (2001) Where is f2? (1997) Expert tech support -- a fast and simple solution (long) ... (2000) File upload woes (1998) Test (2007) [ConvertChars] problem (1997) Separate SSL Server (1997) Snake Bites (1997) using showpage and showcart commands (1996) problems with WebCat-Plugin () RE: Can a database get stomped by simultaneous access? (1997) WebCatalog for guestbook ? (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) 2nd WebCatalog2 Feature Request (1996) Loosing Quantity (2000)