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:

    
  1. Re: [WebDNA] multi [sendmail] inside [search] (WebDNA Solutions 2012)
  2. Re: [WebDNA] multi [sendmail] inside [search] ("Terry Wilson" 2012)
  3. Re: [WebDNA] multi [sendmail] inside [search] (Stephen Braun 2012)
  4. Re: [WebDNA] multi [sendmail] inside [search] (William DeVaul 2012)
  5. Re: [WebDNA] multi [sendmail] inside [search] ("Terry Wilson" 2012)
  6. Re: [WebDNA] multi [sendmail] inside [search] (Govinda 2012)
  7. Re: [WebDNA] multi [sendmail] inside [search] (Stephen Braun 2012)
  8. Re: [WebDNA] multi [sendmail] inside [search] (Terry Wilson 2012)
  9. Re: [WebDNA] multi [sendmail] inside [search] (Stephen Braun 2012)
  10. Re: [WebDNA] multi [sendmail] inside [search] (WebDNA Solutions 2012)
  11. Re: [WebDNA] multi [sendmail] inside [search] (Stuart Tremain 2012)
  12. Re: [WebDNA] multi [sendmail] inside [search] (Stuart Tremain 2012)
  13. Re: [WebDNA] multi [sendmail] inside [search] (Govinda 2012)
  14. Re: [WebDNA] multi [sendmail] inside [search] (Terry Wilson 2012)
  15. Re: [WebDNA] multi [sendmail] inside [search] (Stephen Braun 2012)
  16. Re: [WebDNA] multi [sendmail] inside [search] (Stephen Braun 2012)
  17. RE: [WebDNA] multi [sendmail] inside [search] ("Michael A. DeLorenzo" 2012)
  18. Re: [WebDNA] multi [sendmail] inside [search] (Govinda 2012)
  19. Re: [WebDNA] multi [sendmail] inside [search] (WebDNA Solutions 2012)
  20. Re: [WebDNA] multi [sendmail] inside [search] (Tom Duke 2012)
  21. Re: [WebDNA] multi [sendmail] inside [search] (Stephen Braun 2012)
  22. Re: [WebDNA] multi [sendmail] inside [search] (WebDNA Solutions 2012)
  23. [WebDNA] multi [sendmail] inside [search] (Stephen Braun 2012)
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:

WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) [SQL Connect] (2007) Cart date/time (2006) CloseDataBase vs CommitDataBase (2007) switching users (1998) Subtotal Not Calculated on Invoice.html (1998) [cart] generation (1998) Sort Order on a page search (1997) OT: Unix Find Question (2004) Banners and sort of random display (1997) Database Options (1997) year 2000 + and webmerch, macauth? (1998) RE: creating writefile data from a nested search (1997) WebDNA tags in WebMerchant email templates ... (1997) Generating Report Totals (1997) Printing a final order (1997) Emailer setup (1997) [sendmail] and [formvariables] (1997) Location of Webcat site in folder hierarchy (1997) [cart] Taxrate - seriously .. (2002)