google, isEmail +site:cflib.org
You won't be able to use the query attribute on cfmail if you have
badly formatted email addresses in your database though... unless you
loop through the query and "correct" or "remove" the rows with invalid
email addresses first using the UDF you find on cflib.
Rick
On 5/1/07, Josh Nathanson <[EMAIL PROTECTED]> wrote:
> > I've got a database that didn't use form validation and some email
> > addresses are
> > not valid. So before I use the cfmail tag to send these out how can I
> > check to make
> > sure it's a valid email address?
>
> It depends what you mean by "valid". You can check for valid syntax on the
> fly using isValid("email",email) (CF7 only). At least this will allow you
> to get through the whole list without generating an error.
>
> Checking to see if the email box exists on a server somewhere is another
> issue and is more tricky to handle - there are solutions out there to handle
> that though. I don't think you want to do that on the fly as it's quite
> slow.
>
> Mmmm, yogurt.
>
> -- Josh
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276655
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
