[cfaussie] RE: CFMAIL and validating email address

[Claude Raiola]

Title: AustAccomm Stationery

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