I have a db with email addresses, I only want to retrieve those with
"AOL.com" domains.
I've tried the function #right(emailaddress, 7)# in a query statement in the
WHERE clause, and using the VARIABLE.emailext without success.
Here's the code:
++++++++++++++++++
<!--- Used to check if the subscriber has an AOL email address
<cfset VARIABLES.emailext = Right(emailaddress, 7)>--->
<!--- End AOL Check --->
<!--- Query for the AOL addresses --->
<cfquery name="qAOLMessages" datasource="#REQUEST.dsn1#">
SELECT emailaddress
FROM E1_EmailAdr
WHERE emailaddress IN ('AOL.com')
</cfquery>
<cfoutput>AOL Records = #qAOLMessages.recordcount#</cfoutput>
++++++++++++++++++
Thanks, Mark
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
