[cfaussie] RE: CFMAIL and validating email address

Barry Beattie Sun, 23 May 2004 22:46:52 -0700

Title: AustAccomm Stationery

by rights you should validate before you put it into the db. only good stuff gets stored.

you’ve got three options:

- validate on entry/save (parse the spreadsheet data and/or set up excel macros on the excel fields to only accept valid email formats)

- clean the data: CFSchedual the reading of the data in the db, validating and logging as you go

- validate on output/use: eg just before cfmail (what you’re trying to avoid)

If you’ve got little control over in or out, perhaps a schedualed job is the way to go. You could write to a db table the bad emails and when you last scanned the table, if there were any more uploads, etc

if more excel uploaded (really: if the clean flag EQ false)

clean emails, log and set clean flag to true

else

‘— don’t need an else, you’ve already cleaned what’s there, go home

end if

just an idea

barry.b

From: Claude Raiola [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 May 2004 2:53 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: CFMAIL and validating email address

the problem here is that the email address are not being entered via a form rather they are data entered into a excel spreadsheet by the client and then that spreadsheet is uploaded to the database prior to processing the cfmail

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Peter Tilbrook
Sent: Monday, 24 May 2004 2:29 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: CFMAIL and validating email address

Not that I am aware of, but you can validate them before they are inserted (for correctness only) in your form before it is submitted.

eg:

<cfform ...>

<h5>E-mail Address:<br>
<cfinput type="text" name="UserEmailAddress" maxlength="255" size="40" required="yes" message="Please enter a valid E-mail Address." validate="regular_expression" pattern="([EMAIL PROTECTED],3})"></h5>

</cfform>

Peter Tilbrook
Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA

Telephone: +61-2-6284-2727
Mobile: +61-0439-401-823
E-mail: [EMAIL PROTECTED]

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Claude Raiola
Sent: Monday, 24 May 2004 2:14 PM
To: CFAussie Mailing List
Subject: [cfaussie] CFMAIL and validating email address

Is there a way that I can validate email address in a database rather than waiting for them to be validated during the cfmail function

Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Mobile: 0414 228 948
Phone: 07 5538 5961
Fax: 07 3319 6444
Websites:
     www.AustralianAccommodation.com
     www.AccommodationNewZealand.com
     www.HospitalityPurchasing.net
     www.Samaris.net

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004 ---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

[cfaussie] RE: CFMAIL and validating email address

Reply via email to