Re: won't [sendmail] inside of a [search]
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69283
interpreted = N
texte = Instead of trying to fight the error you could just work with it...[text]message=[/text][search db=../reservations0708.db&geSKUdata=1&neLIVEdatarq=No&geFORMATTED_DATEdata=[date]&asFORMATTED_DATEsort=1&FORMATTED_DATEtype=date][founditems][showif [url][newvar][/url]=[url][FORMATTED_DATE][/url]][text]message=
Event Reservation DatabaseThis is an automated e-mail reminder of upcoming events[include the data I want about the upcoming event] [/text][/showif][/founditems][/search][hideif [url][message][/url]=][sendmail to=me@myemail.org&from=Theatre@www.oswego.org&subject=PerformanceReminder from Theatreweb page on [date] [TIME format=%I:%M:%S]&Content-Type=text/html] [message][/sendmail][/hideif]Matthew A PerosiPsi Prime, Inc.http://www.psiprime.com323 Union Blvd.Totowa, NJ 07512P: 973.413.8210F: 973.413.8217sbraun1@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 > 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:
Instead of trying to fight the error you could just work with it...[text]message=[/text][search db=../reservations0708.db&geSKUdata=1&neLIVEdatarq=No&geFORMATTED_DATEdata=[date]&asFORMATTED_DATEsort=1&FORMATTED_DATEtype=date][founditems][showif [url][newvar][/url]=[url][FORMATTED_DATE][/url]][text]message=Event Reservation DatabaseThis is an automated e-mail reminder of upcoming events[include the data I want about the upcoming event] [/text][/showif][/founditems][/search][hideif [url][message][/url]=][sendmail to=me@myemail.org&from=Theatre@www.oswego.org&subject=PerformanceReminder from Theatreweb page on [date] [TIME format=%I:%M:%S]&Content-Type=text/html] [message][/sendmail][/hideif]Matthew A PerosiPsi Prime, Inc.http://www.psiprime.com323 Union Blvd.Totowa, NJ 07512P: 973.413.8210F: 973.413.8217sbraun1@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 > 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/
Matthew A Perosi
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:
unable to launch acgi in WebCat (1997)
Unexpected error (1997)
Flag checking (2000)
Setting up shop (1997)
createfolder default behavior (1998)
Banners (1997)
Databases.tpl (2000)
Error Lob.db records error message not name (1997)
no global [username] or [password] displayed ... (1997)
[OT] SQL and Crackers (2000)
Web Browser %Numbers - A must read for web developers (2003)
military time (2002)
SKU number. (2000)
FW: Information Regarding Recent Payment Gateway SystemDifficult (2002)
PSC recommends what date format yr 2000??? (1997)
What date is it anyway? (2004)
System 8.5.1 question (1999)
The & Problem (1998)
Here we go again... (2006)
Searching/sorting dates (1997)