Daniel Hikel wrote: > I know a litte OFF, but may be there is also a CF solution to validate > email. > > I tried select XXX FROM YYY where email LIKE '[EMAIL PROTECTED]' > but this regression does noot work for emails like [EMAIL PROTECTED] also
The root of the problem is that this regex is way too restrictive. For instance, it will also filter numbers and underscores. A full description of the syntax of an email address is available from RFC 2822, beter regex's are available in the list archives. When you have a good regex, the proper syntax to plug it into PostgreSQL case-insensitively is SELECT x FROM y WHERE email ~* 'regex' > I want to check on the top-level (max. 3 letters). So my .info address is not allowed? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4