Thanks! Was RE: CFmail and receiving 1 copy
I would like to thank all the great responses on this. I elected to do the separate emails that Jared suggested. Seemed to work best with my Oracle database. Jim W -Original Message- From: James Watkins [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:33 AM To: CF-Talk Subject: CFmail and receiving 1 copy When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190982 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Thanks! Was RE: CFmail and receiving 1 copy
Hey, cool... Glad to help out! Laterz, J On Tue, 18 Jan 2005 15:18:42 -0500, James Watkins [EMAIL PROTECTED] wrote: I would like to thank all the great responses on this. I elected to do the separate emails that Jared suggested. Seemed to work best with my Oracle database. Jim W Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191008 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
Bcc ? .. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190675 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFmail and receiving 1 copy
What about this: cfloop index=i From=0 to=#Getmail.RecordCount# cfif i cfset MailTo= GetMail.Student[i] cfelse cfset MailTo= MyEmailAddress /cfif cfmail To=#MailTo# Blah Blah /cfmail /cfloop Now your query stays in the original state and the cfif clarifies what youre doing. I just prefer not having the two calls, since the objective is to receive what your recipients receive, and any changes to the one cfmail must also be made to the other cfmail. By simply adding your email to the recordset you ensure that you only have one place to make changes. I recognize that a variable is likely to be used for email body and subject, but I'm also thinking about such changes as adding enctype, attachments, setting type to html, having alternate email methods, etc. There's nothing inherently wrong with two email calls, I just like to think ahead as far as reasonable and if the solution doesn't call for significant extra work, then planning for some eventualities can be helpful during the 70% of the application's lifecycle that constitutes the maintenance phase... -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 1:31 PM To: CF-Talk Subject: RE: CFmail and receiving 1 copy From: Calvin Ward [mailto:[EMAIL PROTECTED] The other solutions aren't as ideal for various reasons, in my opinion. What si wrong with the two cfmail tag calls? 1 call passing in the query and 1 call to the 1 recipient? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
this might work. cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address# from=#mailfrom# subject=Greetings email body /cfmail -Original Message- From: James Watkins [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:33 AM To: CF-Talk Subject: CFmail and receiving 1 copy When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Purchase Studio MX with Flash Pro from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=51 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190422 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
That would display everyone's email to the recipients... You could also do this: cfmail to=# your_email_address# cc=# valuelist(mail_roster.student)# from=#mailfrom# subject=Greetings email body /cfmail - Calvin -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:40 AM To: CF-Talk Subject: RE: CFmail and receiving 1 copy this might work. cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address# from=#mailfrom# subject=Greetings email body /cfmail -Original Message- From: James Watkins [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:33 AM To: CF-Talk Subject: CFmail and receiving 1 copy When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190424 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
yeah, i thought about that afterwards. ;-) -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 8:17 AM To: CF-Talk Subject: RE: CFmail and receiving 1 copy That would display everyone's email to the recipients... You could also do this: cfmail to=# your_email_address# cc=# valuelist(mail_roster.student)# from=#mailfrom# subject=Greetings email body /cfmail - Calvin -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:40 AM To: CF-Talk Subject: RE: CFmail and receiving 1 copy this might work. cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address# from=#mailfrom# subject=Greetings email body /cfmail -Original Message- From: James Watkins [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:33 AM To: CF-Talk Subject: CFmail and receiving 1 copy When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190425 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
That would also display the address to everyone. You must use bcc for that... that is why it is called Blind Carbon Copy. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190428 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
Not sure if it works, but could be something like: CFOUTPUT QUERY=mail_roster CFMAIL TO=#student# FROM=#mailfrom# BCC=CFIF mail_roster.current_row EQ 1#sendOnetoMe#/CFIF SUBJECT=Greetings BLAH BLAH BLAH /CFMAIL /CFOUTPUT -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:40 AM To: CF-Talk Subject: RE: CFmail and receiving 1 copy this might work. cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address# from=#mailfrom# subject=Greetings email body /cfmail -Original Message- From: James Watkins [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:33 AM To: CF-Talk Subject: CFmail and receiving 1 copy When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190430 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
I missed changing that, which was what my actual intention was... so much for being in a hurry! -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 8:54 AM To: CF-Talk Subject: RE: CFmail and receiving 1 copy That would also display the address to everyone. You must use bcc for that... that is why it is called Blind Carbon Copy. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Purchase RoboHelp from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=59 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
I don't think you can nest tags inside attributes.
However, this may be closer:
cfscript
Function setBCC(row) {
var result = '';
if (row EQ 1)
result = myEmail;
return result;
}
/cfscript
CFOUTPUT QUERY=mail_roster
CFMAIL TO=#student#
FROM=#mailfrom#
BCC=#setBCC(mail_roster.CurrentRow)#
SUBJECT=Greetings
BLAH BLAH BLAH
/CFMAIL
/CFOUTPUT
Doesn't CFMX choke on blank mail addresses though?
- Calvin
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 9:02 AM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
Not sure if it works, but could be something like:
CFOUTPUT QUERY=mail_roster
CFMAIL TO=#student#
FROM=#mailfrom#
BCC=CFIF mail_roster.current_row EQ
1#sendOnetoMe#/CFIF
SUBJECT=Greetings
BLAH BLAH BLAH
/CFMAIL
/CFOUTPUT
-Original Message-
From: John Stanley [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 7:40 AM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
this might work.
cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address#
from=#mailfrom# subject=Greetings
email body
/cfmail
-Original Message-
From: James Watkins [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 7:33 AM
To: CF-Talk
Subject: CFmail and receiving 1 copy
When sending email to a list of several hundred students using CFmail I
would like to receive just 1 copy of what I send. How can I modify below
to do that?
cfmail query=mail_roster
to = #student#
from = #mailfrom#
subject = Greetings
blah, blah
/cfmail
Jim Watkins
Vice President of
Technology Institutional Services
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190432
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
try this CFMAIL QUERY=mail_roster TO=#mail_roster.student# FROM=#mailfrom# BCC=#IIf(mail_roster.current_row is 1,sendOnetoMe,DE())# SUBJECT=Greetings BLAH BLAH BLAH /CFMAIL /t -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 3:02 PM To: CF-Talk Subject: RE: CFmail and receiving 1 copy Not sure if it works, but could be something like: CFOUTPUT QUERY=mail_roster CFMAIL TO=#student# FROM=#mailfrom# BCC=CFIF mail_roster.current_row EQ 1#sendOnetoMe#/CFIF SUBJECT=Greetings BLAH BLAH BLAH /CFMAIL /CFOUTPUT -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:40 AM To: CF-Talk Subject: RE: CFmail and receiving 1 copy this might work. cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address# from=#mailfrom# subject=Greetings email body /cfmail -Original Message- From: James Watkins [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 7:33 AM To: CF-Talk Subject: CFmail and receiving 1 copy When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190433 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
From: James Watkins [mailto:[EMAIL PROTECTED] When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail How about: !--- Send to recipients using query results --- cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail !--- Send yourself a copy --- cfmail to = you from = you subject = Greetings blah, blah /cfmail Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190437 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFmail and receiving 1 copy
Why not add a row to the query before the CFMAIL tag? cfscript QueryAddRow(mail_roster,1); QuerySetCell(mail_roster,student,[EMAIL PROTECTED]); /cfscript Downside is, of course, if you use the query result later on your address is added in. On Fri, 14 Jan 2005 07:33:13 -0500, James Watkins [EMAIL PROTECTED] wrote: When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Purchase Studio MX with Flash Pro from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=51 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190445 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFmail and receiving 1 copy
Why not simply do this: cfmail to = #me# from = #mailfrom# subject = Greetings blah, blah /cfmail cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail In that case, each cfmail tag is cohesive, in that it can be allowed to work as designed for a more narrow purpose without having to work out unusual or creative workarounds for its innate features. If you have to add tweaky things to the CFMAIL tag, which can have enough bugs of it's own, then perhaps executing 2 calls (especially since each call has an entirely different purpose, method, and attribute set) is really the best idea. Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com On Fri, 14 Jan 2005 10:24:48 -0500, Al Everett [EMAIL PROTECTED] wrote: Why not add a row to the query before the CFMAIL tag? cfscript QueryAddRow(mail_roster,1); QuerySetCell(mail_roster,student,[EMAIL PROTECTED]); /cfscript Downside is, of course, if you use the query result later on your address is added in. On Fri, 14 Jan 2005 07:33:13 -0500, James Watkins [EMAIL PROTECTED] wrote: When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190449 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
That's what makes a discussios so great, look at all the options you get! Udf in BCC IIF in BCC Separate cfmail Add email to record set - Calvin -Original Message- From: Al Everett [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 10:25 AM To: CF-Talk Subject: Re: CFmail and receiving 1 copy Why not add a row to the query before the CFMAIL tag? cfscript QueryAddRow(mail_roster,1); QuerySetCell(mail_roster,student,[EMAIL PROTECTED]); /cfscript Downside is, of course, if you use the query result later on your address is added in. On Fri, 14 Jan 2005 07:33:13 -0500, James Watkins [EMAIL PROTECTED] wrote: When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190450 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFmail and receiving 1 copy
True, Calvin... and sometimes you get really great advice! Sometimes you end up with a mishmash of options that just mean you know less than you started out with. Gotta love it. But as a side note, I've done things like all 4 of the below, thinking I was doing really great stuff by altering the behaviors of things to be creative in my development. What you generally end up with is something that's cool and unique, and hard to support, and easily broken. If you've got 2 separate cfmail tags, you can tell at a glance what each does, you have no extra code to read thru to remember what you did or figure out what someone else did, you have 2 tags that execute as purposed, each of those tags executes quite efficiently, and there's nothing else going on. Of ALL the options we've discussed, other than 2 separate tags and individual emails to each student, the only other option I'd really go for is: cfmail to=[EMAIL PROTECTED] bcc=#valueList(student_query)# And that I'd want to test, VERY thouroughly, to insure that on the off chance I end up with a student_query that's over 1,000 records I wasn't going to bomb the app. And I'd include a failto= attribute (if you're using 6.1 anyway) in case the messages fail. If you use 2 separate tags, each student gets their own copy, which is essentially how cfmail was intended to work in the first place. If you use the BCC attribute, you're handing the responsibility for the success of a much larger single operation off to an external system (the mail server), whereas if you use single emails from 2 cfmail tags you can be relatively certain that (being a simpler, smaller act of sending on mail to one recip for each row in the query) it will succeed. If I were going for creative I'd say hell yeah, do it however and tell us what nifty thing it was. I used to do that. At this point, I get more satisfaction from developing something that's standards-based, rock-solid, and as self-contained and cohesive as possible. Ain't tellin ya what to do, just why I'd do what I'd do. Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com On Fri, 14 Jan 2005 10:40:49 -0500, Calvin Ward [EMAIL PROTECTED] wrote: That's what makes a discussios so great, look at all the options you get! Udf in BCC IIF in BCC Separate cfmail Add email to record set - Calvin ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190462 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFmail and receiving 1 copy
I did just think of one other option that may not be so bad... if you init a counter at 0: cfset counter=0 and then use a conditional loop: cfloop condition = counter EQ query.recordcount cfmail to= Nope, still ain't gonna cut it. It's a bunch of extra code and work when the functionality to just send it out is already there... Well, I tried to find a funky way that was better but I still can't convince myself that when a tool is built in to the system, there's a reasonable way to do the same work by altering the system's built-in methods. Oh well... Back to sequence diagrams... fun fun! Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com On Fri, 14 Jan 2005 07:33:13 -0500, James Watkins [EMAIL PROTECTED] wrote: When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Protect Your PC from viruses, hackers, spam and more. Buy PC-cillin with Easy Installation Support http://www.houseoffusion.com/banners/view.cfm?bannerid=61 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190463 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
In addition to the options you get in the discussion, you also get discussion of the options, and we all learn from it :) Actually, of the four, I prefer the Add record to the record set solution best, since you don't muddy the usage of the cfmail code, and additionally you get exactly what was sent to the other recipients. The other solutions aren't as ideal for various reasons, in my opinion. - Calvin -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 11:59 AM To: CF-Talk Subject: Re: CFmail and receiving 1 copy True, Calvin... and sometimes you get really great advice! Sometimes you end up with a mishmash of options that just mean you know less than you started out with. Gotta love it. But as a side note, I've done things like all 4 of the below, thinking I was doing really great stuff by altering the behaviors of things to be creative in my development. What you generally end up with is something that's cool and unique, and hard to support, and easily broken. If you've got 2 separate cfmail tags, you can tell at a glance what each does, you have no extra code to read thru to remember what you did or figure out what someone else did, you have 2 tags that execute as purposed, each of those tags executes quite efficiently, and there's nothing else going on. Of ALL the options we've discussed, other than 2 separate tags and individual emails to each student, the only other option I'd really go for is: cfmail to=[EMAIL PROTECTED] bcc=#valueList(student_query)# And that I'd want to test, VERY thouroughly, to insure that on the off chance I end up with a student_query that's over 1,000 records I wasn't going to bomb the app. And I'd include a failto= attribute (if you're using 6.1 anyway) in case the messages fail. If you use 2 separate tags, each student gets their own copy, which is essentially how cfmail was intended to work in the first place. If you use the BCC attribute, you're handing the responsibility for the success of a much larger single operation off to an external system (the mail server), whereas if you use single emails from 2 cfmail tags you can be relatively certain that (being a simpler, smaller act of sending on mail to one recip for each row in the query) it will succeed. If I were going for creative I'd say hell yeah, do it however and tell us what nifty thing it was. I used to do that. At this point, I get more satisfaction from developing something that's standards-based, rock-solid, and as self-contained and cohesive as possible. Ain't tellin ya what to do, just why I'd do what I'd do. Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com On Fri, 14 Jan 2005 10:40:49 -0500, Calvin Ward [EMAIL PROTECTED] wrote: That's what makes a discussios so great, look at all the options you get! Udf in BCC IIF in BCC Separate cfmail Add email to record set - Calvin ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190476 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
From: Calvin Ward [mailto:[EMAIL PROTECTED] The other solutions aren't as ideal for various reasons, in my opinion. What si wrong with the two cfmail tag calls? 1 call passing in the query and 1 call to the 1 recipient? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFmail and receiving 1 copy
OK, I'll go with you on that one... And thinking about it again, you don't have to handle the email content twice, either. You basically extend the concept of recipient by adding yourself to it. I've been buried in studying OO these days, so I'm thinking differently than I did for a long time. If you add yourself to the recipient list, you have to abstract the idea of recipient from the idea of student because all recipients aren't students. In this case, then, me and student extend recipients, since the desired result is to get an email to all the recipients. me IS-A recipient and student IS-A recipient but me IS-NOT a student. So wouldn't this put me in a class by myself? Hehe, ok, that was lame, but somehow I just couldn't resist... Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com On Fri, 14 Jan 2005 13:04:59 -0500, Calvin Ward [EMAIL PROTECTED] wrote: In addition to the options you get in the discussion, you also get discussion of the options, and we all learn from it :) Actually, of the four, I prefer the Add record to the record set solution best, since you don't muddy the usage of the cfmail code, and additionally you get exactly what was sent to the other recipients. The other solutions aren't as ideal for various reasons, in my opinion. - Calvin ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
I just prefer not having the two calls, since the objective is to receive what your recipients receive, and any changes to the one cfmail must also be made to the other cfmail. By simply adding your email to the recordset you ensure that you only have one place to make changes. I recognize that a variable is likely to be used for email body and subject, but I'm also thinking about such changes as adding enctype, attachments, setting type to html, having alternate email methods, etc. There's nothing inherently wrong with two email calls, I just like to think ahead as far as reasonable and if the solution doesn't call for significant extra work, then planning for some eventualities can be helpful during the 70% of the application's lifecycle that constitutes the maintenance phase... -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 1:31 PM To: CF-Talk Subject: RE: CFmail and receiving 1 copy From: Calvin Ward [mailto:[EMAIL PROTECTED] The other solutions aren't as ideal for various reasons, in my opinion. What si wrong with the two cfmail tag calls? 1 call passing in the query and 1 call to the 1 recipient? ~| Get help! RoboHelp http://www.houseoffusion.com/banners/view.cfm?bannerid=58 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190482 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFmail and receiving 1 copy
There's nothing wrong with two calls to CFMAIL... In fact, there's still something to be said for letting one call be a 1-to-1 operation and the other call be a query-driven operation, allowing CFMAIL to do each thing seperately as intended. But Calvin has a point, in that it makes for 2 points to update, if need be. It isn't really reasonable to debate the viability of either way without discussing a slightly larger view of the system. What surrounds this cfmail operation? Is there a unified process that creates all the parameters that drives it? Can 2 calls to CFMAIL be created with the same set of parameters being provided by other sources? Many of these design decisions are driven by context and specific need... without a little more context, it's difficult to say which is best. If you had a SendCfmail class that took all of its parameters from the caller, then issuing 2 calls successively could be done without worry that things would change between them. In that case, separate SendCfmail messages could be sent, one with a query object being passed in and one with an individual recipient. However, if your focus was on the recipient class, you could argue that adding yourself to the recipients would be more in line with the process's intent, and the addToQuery(me) call would be more appropriate. It entirely depends on the context, forces, and requirements of the situation. YMMV, but that's why I've become a huge proponent of models and OO lately... it answers those questions before you're too invested in one method, only to find out that it doesn't work quite like you wanted to. Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com On Fri, 14 Jan 2005 13:31:03 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: From: Calvin Ward [mailto:[EMAIL PROTECTED] The other solutions aren't as ideal for various reasons, in my opinion. What si wrong with the two cfmail tag calls? 1 call passing in the query and 1 call to the 1 recipient? ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
