Re: [WebDNA] multi [sendmail] inside [search]
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 109301
interpreted = N
texte = Hi Stephen, =46irst of all, I think Micheal DeLorenzo's=20 solution is the best for all the reasons he=20 mentioned. That said, like others who have chimed in, I've=20 been using sendmail within searches for years.=20 How else to insert record-based info? You did not give us your code, only shorthand=20 like "code..blah..code..." which isn't useful.=20 It's probable that we can find your error if you=20 would give us the actual code. Terry >Kenneth, > >Here is my test code. >It does both of your [writefile] commands=20 >perfectly, with several of my test employees,=20 >but does not do the [sendmail] in between. >I was told that it is because the [sendmail] is inside of the [search] > > [writefile testFounditemStart[index]][message_total_hours][/writefile] > [sendmail=20 >to=3Dsbraun1@twcny.rr.com&from=3DWebpage@mydomain.com&subject=3DTest=20 >Over 40 message (no=20 >reply)&content-type=3Dtext/html]=A0=A0=A0=A0=A0 > [message_total_hours]=A0 > [/sendmail] > [writefile testFounditemEnd[index]][message_total_hours][/writefile] > >I don't have access to the server to check any=20 >of the settings, or know the platform. > > > > > >On Jul 13, 2012, at 11:07 AM, WebDNA Solutions wrote: > >> There must be something wrong with your real code, >> unless it's a temporary glitch that requires a reboot >> to clear it up.=A0 >> >> First reboot the server, then try your original code >> again to see if it's working the way it should. If not, >> try this as a test:=A0=A0=A0=A0=A0=A0=A0 >> >> [search db=3D../login/website_users.db& code..blah..code...] >> >> [writefile testNumfound][numfound][/writefile] >> >> [founditems]=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 >> code..blah..code... >> [showif code..blah..code... >> [loop start=3D[=20 >>code..blah..code...]=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 >> [text] message =3D >> [showif code..blah..code... >> [/showif] >> [/text] >> [/loop] >> [/showif]=A0=A0 >> >> [writefile testFounditemStart[index]][message][/writefile] >> >> [sendmail >> to=3Dtimeclock@domain.com&from=3DWebpage@domain.com&subject=3DStaff Over >> 40 message (no reply)&content-type=3Dtext/html] >> [message] >> [/sendmail] >> >> [writefile testFounditemEnd[index]][message][/writefile] >> >> code..blah..code... >> [/founditems] >> [/search] >> >> ... then see if the content of the testNumfound file matches >> the number of testFounditemStart and testFounditemEnd >> files -- and check the content of these files to be sure they >> contain the correct message.=A0 >> >> Sincerely, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> WebDNA Programming and Linux Server Administration >> >> >> >> >> >> >> >>> On Jul 13, 2012, at 10:04 AM, WebDNA Solutions wrote: >>>>> The problem is, WebDNA doesn't like using a [sendmail] >>>>> tag inside of a [search...][founditems] routine. >>>> >>>> Of course it does, I've been doing this for years. >>>> What seems to be the problem that causes you to say >>>> this? >>> >>> The simple problem is that it won't work... >>> Here's a sample.... >>> >>> [search db=3D../login/website_users.db& >>> code..blah..code...] [founditems] >>> code..blah..code... >>> [showif code..blah..code... >>> [loop start=3D[ code..blah..code...] >>> [text] message =3D >>> [showif code..blah..code... >>> [/showif] >>> [/text] >>> [/loop] >>> [/showif] >>> [sendmail >>> to=3Dtimeclock@domain.com&from=3DWebpage@domain.com&subject=3D >>> Staff Over 40 message (no reply)&content-type=3Dtext/html] >>> [message] >>> [/sendmail] >>> code..blah..code... >>> [/founditems] >>> [/search] >>> >>> But this does work, but with only the last item found.... >>> >>> [search db=3D../login/website_users.db& > >> code..blah..code...] [founditems] >>> code..blah..code... >>> [showif code..blah..code... >>> [loop start=3D[ code..blah..code...] >>> [text] message =3D >>> [showif code..blah..code... >>> [/showif] >>> [/text] >>> [/loop] >>> [/showif] >>> code..blah..code... >>> [/founditems] >>> [/search] >>> >>> [sendmail to=3Dtimeclock@domain.com&from=3DWebpage@ >>> domain.com&subject=3DStaff Over 40 message (no >>> reply)&content-type=3Dtext/html] [message] >>> [/sendmail] >>> >>>> Sincerely, >>>> Kenneth Grome >>>> WebDNA Solutions >>>> http://www.webdnasolutions.com >>>> WebDNA Programming and Linux Server Administration >>>> >>>> ------------------------------------------------------- >>>> -- This message is sent to you because you are >>>> subscribed to the mailing list
. >>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>> Bug Reporting: support@webdna.us >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us > >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: >archives: http://mail.webdna.us/list/talk@webdna.us >Bug Reporting: support@webdna.us -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system iStockPhoto portfolio - http://www.istockphoto.com/Terryfic3D?refnum=3DTerry= fic3D -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Associated Messages, from the most recent to the oldest:
Hi Stephen, =46irst of all, I think Micheal DeLorenzo's=20 solution is the best for all the reasons he=20 mentioned. That said, like others who have chimed in, I've=20 been using sendmail within searches for years.=20 How else to insert record-based info? You did not give us your code, only shorthand=20 like "code..blah..code..." which isn't useful.=20 It's probable that we can find your error if you=20 would give us the actual code. Terry >Kenneth, > >Here is my test code. >It does both of your [writefile] commands=20 >perfectly, with several of my test employees,=20 >but does not do the [sendmail] in between. >I was told that it is because the [sendmail] is inside of the [search] > > [writefile testFounditemStart[index]][message_total_hours][/writefile] > [sendmail=20 >to=3Dsbraun1@twcny.rr.com&from=3DWebpage@mydomain.com&subject=3DTest=20 >Over 40 message (no=20 >reply)&content-type=3Dtext/html]=A0=A0=A0=A0=A0 > [message_total_hours]=A0 > [/sendmail] > [writefile testFounditemEnd[index]][message_total_hours][/writefile] > >I don't have access to the server to check any=20 >of the settings, or know the platform. > > > > > >On Jul 13, 2012, at 11:07 AM, WebDNA Solutions wrote: > >> There must be something wrong with your real code, >> unless it's a temporary glitch that requires a reboot >> to clear it up.=A0 >> >> First reboot the server, then try your original code >> again to see if it's working the way it should. If not, >> try this as a test:=A0=A0=A0=A0=A0=A0=A0 >> >> [search db=3D../login/website_users.db& code..blah..code...] >> >> [writefile testNumfound][numfound][/writefile] >> >> [founditems]=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 >> code..blah..code... >> [showif code..blah..code... >> [loop start=3D[=20 >>code..blah..code...]=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 >> [text] message =3D >> [showif code..blah..code... >> [/showif] >> [/text] >> [/loop] >> [/showif]=A0=A0 >> >> [writefile testFounditemStart[index]][message][/writefile] >> >> [sendmail >> to=3Dtimeclock@domain.com&from=3DWebpage@domain.com&subject=3DStaff Over >> 40 message (no reply)&content-type=3Dtext/html] >> [message] >> [/sendmail] >> >> [writefile testFounditemEnd[index]][message][/writefile] >> >> code..blah..code... >> [/founditems] >> [/search] >> >> ... then see if the content of the testNumfound file matches >> the number of testFounditemStart and testFounditemEnd >> files -- and check the content of these files to be sure they >> contain the correct message.=A0 >> >> Sincerely, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> WebDNA Programming and Linux Server Administration >> >> >> >> >> >> >> >>> On Jul 13, 2012, at 10:04 AM, WebDNA Solutions wrote: >>>>> The problem is, WebDNA doesn't like using a [sendmail] >>>>> tag inside of a [search...][founditems] routine. >>>> >>>> Of course it does, I've been doing this for years. >>>> What seems to be the problem that causes you to say >>>> this? >>> >>> The simple problem is that it won't work... >>> Here's a sample.... >>> >>> [search db=3D../login/website_users.db& >>> code..blah..code...] [founditems] >>> code..blah..code... >>> [showif code..blah..code... >>> [loop start=3D[ code..blah..code...] >>> [text] message =3D >>> [showif code..blah..code... >>> [/showif] >>> [/text] >>> [/loop] >>> [/showif] >>> [sendmail >>> to=3Dtimeclock@domain.com&from=3DWebpage@domain.com&subject=3D >>> Staff Over 40 message (no reply)&content-type=3Dtext/html] >>> [message] >>> [/sendmail] >>> code..blah..code... >>> [/founditems] >>> [/search] >>> >>> But this does work, but with only the last item found.... >>> >>> [search db=3D../login/website_users.db& > >> code..blah..code...] [founditems] >>> code..blah..code... >>> [showif code..blah..code... >>> [loop start=3D[ code..blah..code...] >>> [text] message =3D >>> [showif code..blah..code... >>> [/showif] >>> [/text] >>> [/loop] >>> [/showif] >>> code..blah..code... >>> [/founditems] >>> [/search] >>> >>> [sendmail to=3Dtimeclock@domain.com&from=3DWebpage@ >>> domain.com&subject=3DStaff Over 40 message (no >>> reply)&content-type=3Dtext/html] [message] >>> [/sendmail] >>> >>>> Sincerely, >>>> Kenneth Grome >>>> WebDNA Solutions >>>> http://www.webdnasolutions.com >>>> WebDNA Programming and Linux Server Administration >>>> >>>> ------------------------------------------------------- >>>> -- This message is sent to you because you are >>>> subscribed to the mailing list . >>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>> Bug Reporting: support@webdna.us >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us > >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: >archives: http://mail.webdna.us/list/talk@webdna.us >Bug Reporting: support@webdna.us -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system iStockPhoto portfolio - http://www.istockphoto.com/Terryfic3D?refnum=3DTerry= fic3D -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Terry Wilson
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:
Trouble with formula.db (1997)
& in Lookups (1997)
OSX (2003)
Follow-up to listfiles bug report ... (2003)
Simple Database close connection (2001)
webcat nt (1997)
default value from Lookup (was Grant, please help me) (1997)
Frames and WebCat (1997)
Sharing with you my Online help system (2006)
math a various prices (1997)
Tea Room trouble (1997)
pc (1997)
Snake Bites (1997)
Reminder for beta testers (2000)
Hidden or Forbidden? (1998)
Mac v. NT (1998)
[cart] clarification... (1997)
Bad spawn! Finish your work! (2002)
Deleting Multiple Database Records based on Checkbox (1998)
Nav. 4 probs with cart - Serious problem (1997)