Thanks, Mark
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:28 PM
To: CF-Talk
Subject: RE: SQL record retrieval problem
mark
select * from table where email like '%aol.com'
that should fix you right up ;)
tw
-----Original Message-----
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:26 PM
To: CF-Talk
Subject: SQL record retrieval problem
I'm sure there's an easy way to do this, I'm just can't see it.
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]
