Re: catching a query based cfmail ...
Hmmm... maybe the DAO type-deal, but that's a lot of work. The idea was to do it without looping the query first, so the isValid I don't think would work. The regex I mentioned was basically a way of putting some type of selection in the query itself, saying, Grab me records with valid emails, which I presume the MySQL regex engine is capable of, dunno for sure, and no idea whatsoever about MSSQL and regex. Just spreading out the work load, CF shouldn't have to do it all! ;-) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237849 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: catching a query based cfmail ...
Hi Rick
On cflib.org there is a function titled 'isEmail' I have used this a few
times to validate emails. The function code is a s follows:
cfscript
function isEmail(str) {
return (REFindNoCase(^['_a-z0-9-]+(\.['_a-z0-9-]+)[EMAIL
PROTECTED](\.[a-z0-9-]+)*\.(([a-z]{2,3})|(aero|coop|info|museum|name|jobs|travel))$,arguments.str)
AND len(listGetAt(arguments.str, 1, @)) LTE 64 AND
len(listGetAt(arguments.str, 2, @)) LTE 255) IS 1;
}/cfscript
Another alternative if you are using sql server is to doa sql
function and wrap the email element in that for validation.
Hope this helps
Jose Diaz
On 4/14/06, Denny Valliant [EMAIL PROTECTED] wrote:
A crazy option would be to use a regular expression (available in MySQL)
to
grab only valid emails.
Heh. With the regex stuff going on, had to mention it.
By the by, a useful resource for regex for me has been
www.regular-expressions.com.
:D3|\|*
On 4/13/06, Dawson, Michael [EMAIL PROTECTED] wrote:
I think you are totally correct. You will need to do the CFLOOP thing
to be able to catch an individual CFMAIL exception.
M!ke
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 13, 2006 9:07 PM
To: CF-Talk
Subject: catching a query based cfmail ...
If I'm using cfmail with the query attribute, populating the to address
dynamically... how to I catch an individual exception?
Like if one row in the query contains an invalid email address that
throws a cfmail exception.
If i put try/catch around the whole cfmail tag set it'll actually stop
the whole mailing...
I'm assuming there's no way to do what I want to do without axing the
query attribute and doing something like
cfloop query=foo
cftry
cfmail from=[EMAIL PROTECTED] to=#email# subject=foo
...
/cfmail
cfcatch type=any/cfcatch
/cftry
/cfloop
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237735
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
catching a query based cfmail ...
If I'm using cfmail with the query attribute, populating the to address dynamically... how to I catch an individual exception? Like if one row in the query contains an invalid email address that throws a cfmail exception. If i put try/catch around the whole cfmail tag set it'll actually stop the whole mailing... I'm assuming there's no way to do what I want to do without axing the query attribute and doing something like cfloop query=foo cftry cfmail from=[EMAIL PROTECTED] to=#email# subject=foo ... /cfmail cfcatch type=any/cfcatch /cftry /cfloop ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237724 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: catching a query based cfmail ...
I think you are totally correct. You will need to do the CFLOOP thing to be able to catch an individual CFMAIL exception. M!ke -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:07 PM To: CF-Talk Subject: catching a query based cfmail ... If I'm using cfmail with the query attribute, populating the to address dynamically... how to I catch an individual exception? Like if one row in the query contains an invalid email address that throws a cfmail exception. If i put try/catch around the whole cfmail tag set it'll actually stop the whole mailing... I'm assuming there's no way to do what I want to do without axing the query attribute and doing something like cfloop query=foo cftry cfmail from=[EMAIL PROTECTED] to=#email# subject=foo ... /cfmail cfcatch type=any/cfcatch /cftry /cfloop ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237726 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: catching a query based cfmail ...
A crazy option would be to use a regular expression (available in MySQL) to grab only valid emails. Heh. With the regex stuff going on, had to mention it. By the by, a useful resource for regex for me has been www.regular-expressions.com. :D3|\|* On 4/13/06, Dawson, Michael [EMAIL PROTECTED] wrote: I think you are totally correct. You will need to do the CFLOOP thing to be able to catch an individual CFMAIL exception. M!ke -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:07 PM To: CF-Talk Subject: catching a query based cfmail ... If I'm using cfmail with the query attribute, populating the to address dynamically... how to I catch an individual exception? Like if one row in the query contains an invalid email address that throws a cfmail exception. If i put try/catch around the whole cfmail tag set it'll actually stop the whole mailing... I'm assuming there's no way to do what I want to do without axing the query attribute and doing something like cfloop query=foo cftry cfmail from=[EMAIL PROTECTED] to=#email# subject=foo ... /cfmail cfcatch type=any/cfcatch /cftry /cfloop ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237731 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
