Re: [WebDNA] multi [sendmail] inside [search]
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 109295
interpreted = N
texte = >=20 >>> The problem is, WebDNA doesn't like using a [sendmail] >>> tag inside of a [search...][founditems] routine. >>=20 >> Of course it does, I've been doing this for years. What=20 >> seems to be the problem that causes you to say this? >=20 >=20 > The simple problem is that it won't work... > Here's a sample.... >=20 > [search db=3D../login/website_users.db& code..blah..code...] > [founditems] =20 > code..blah..code... > [showif code..blah..code... > [loop start=3D[ code..blah..code...] = = =09 > [text] message =3D > [showif code..blah..code... > [/showif] > [/text] > [/loop] > [/showif] =20 > [sendmail = to=3Dtimeclock@domain.com&from=3DWebpage@domain.com&subject=3DStaff Over = 40 message (no reply)&content-type=3Dtext/html] > [message] > [/sendmail] > code..blah..code... > [/founditems] > [/search] >=20 > But this does work, but with only the last item found.... >=20 > [search db=3D../login/website_users.db& code..blah..code...] > [founditems] =20 > code..blah..code... > [showif code..blah..code... > [loop start=3D[ code..blah..code...] = = =09 > [text] message =3D > [showif code..blah..code... > [/showif] > [/text] > [/loop] > [/showif] =20 > code..blah..code... > [/founditems] > [/search] >=20 > [sendmail to=3Dtimeclock@domain.com&from=3DWebpage@ = domain.com&subject=3DStaff Over 40 message (no = reply)&content-type=3Dtext/html] > [message] > [/sendmail] Stephen, I also have sent mail using [sendmail] countless times inside a = [search][founditems]... But anyway, as far as the above code (latter example) only sending one = email.. well that makes perfect sense (looking at the code you wrote). = If you want 3 emails to go out, you have to write out 3 [sendmail]'s = ...or put the [sendmail] inside a loop that will fire 3 times (like = inside [founditems] ;-) .. or inside [loop], or inside [listwords], or = inside whatever other loop serves you best. If you do not want to debug = why [sendmail] was failing inside [founditems] on your first attempt, = then you could rewrite your latter attempt, like so: [search db=3D../login/website_users.db& code..blah..code...] [founditems] =20 code..blah..code... [showif code..blah..code... [loop start=3D[code..blah..code...] [text]message_[index] =3D [showif = code..blah..code...[/showif] [/text] = [text]NumTimesLoopFired=3D[index][/text][!]<--- 1.) this might go here, = or else below---[/!] [/loop] [/showif] =20 code..blah..code... [text]NumTimesLoopFired=3D[index][/text][!]<--- 2.) this = might go here, or else above---[/!] [/founditems] [/search] [loop start=3D1&end=3D[NumTimesLoopFired]&advance=3D1] [sendmail to=3Dtimeclock@domain.com&from=3DWebpage@ = domain.com&subject=3DStaff Over 40 message (no = reply)&content-type=3Dtext/html] [interpret][message_[index]][/interpret] [/sendmail] [/loop]
Associated Messages, from the most recent to the oldest:
>=20 >>> The problem is, WebDNA doesn't like using a
[sendmail] >>> tag inside of a [search...]
[founditems] routine. >>=20 >> Of course it does, I've been doing this for years. What=20 >> seems to be the problem that causes you to say this? >=20 >=20 > The simple problem is that it won't work... > Here's a sample.... >=20 > [search db=3D../login/website_users.db& code..blah..code...] >
[founditems] =20 > code..blah..code... > [showif code..blah..code... > [loop start=3D[ code..blah..code...] = = =09 >
[text] message =3D > [showif code..blah..code... > [/showif] > [/text] > [/loop] > [/showif] =20 > [sendmail = to=3Dtimeclock@domain.com&from=3DWebpage@domain.com&subject=3DStaff Over = 40 message (no reply)&content-type=3Dtext/html] > [message] > [/sendmail] > code..blah..code... > [/founditems] > [/search] >=20 > But this does work, but with only the last item found.... >=20 > [search db=3D../login/website_users.db& code..blah..code...] >
[founditems] =20 > code..blah..code... > [showif code..blah..code... > [loop start=3D[ code..blah..code...] = = =09 >
[text] message =3D > [showif code..blah..code... > [/showif] > [/text] > [/loop] > [/showif] =20 > code..blah..code... > [/founditems] > [/search] >=20 > [sendmail to=3Dtimeclock@domain.com&from=3DWebpage@ = domain.com&subject=3DStaff Over 40 message (no = reply)&content-type=3Dtext/html] > [message] > [/sendmail] Stephen, I also have sent mail using
[sendmail] countless times inside a =
[search][founditems]... But anyway, as far as the above code (latter example) only sending one = email.. well that makes perfect sense (looking at the code you wrote). = If you want 3 emails to go out, you have to write out 3
[sendmail]'s = ...or put the
[sendmail] inside a loop that will fire 3 times (like = inside
[founditems] ;-) .. or inside
[loop], or inside
[listwords], or = inside whatever other loop serves you best. If you do not want to debug = why
[sendmail] was failing inside
[founditems] on your first attempt, = then you could rewrite your latter attempt, like so: [search db=3D../login/website_users.db& code..blah..code...]
[founditems] =20 code..blah..code... [showif code..blah..code... [loop start=3D[code..blah..code...]
[text]message_[index] =3D [showif = code..blah..code...[/showif] [/text] =
[text]NumTimesLoopFired=3D[index][/text]
[!]<--- 1.) this might go here, = or else below---[/!] [/loop] [/showif] =20 code..blah..code...
[text]NumTimesLoopFired=3D[index][/text]
[!]<--- 2.) this = might go here, or else above---[/!] [/founditems] [/search] [loop start=3D1&end=3D[NumTimesLoopFired]&advance=3D1] [sendmail to=3Dtimeclock@domain.com&from=3DWebpage@ = domain.com&subject=3DStaff Over 40 message (no = reply)&content-type=3Dtext/html]
[interpret][message_[index]][/interpret] [/sendmail] [/loop]
Govinda
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:
Hiding HTML and breaking the page (1997)
WebCatalog for guestbook ? (1997)
Version 6 Problems (2004)
Exclamation point (1997)
Encyption mail was Suggestions for Topics ... (1998)
international time (1997)
Credit card types (1997)
Authorize.net, SIM, tcpconnect and applescript (2003)
Online Docs for the Beta... (2000)
Spawn problem (2000)
Emailer Error Question (1998)
Setting up shop (1997)
[ModDate] & [ModTime] ? (1997)
Ampersands in database fields? (1998)
blank page from template (1997)
calculating tax rates, mail order solutions and version 2 (1997)
Separate server for jpg/gif files (1998)
suggestion (1997)
Exclude by date - multiple (1997)
Bug? (1997)