Hello - 

I have inherited a web application that is secured with a login.  The user logs 
in with a username, but the only way the user is uniquely identified in the is 
by an email address.

So if user George logs in with the username george123, how can I query the 
database for the an email address that contains "george123?"

Currently, I have

<cfset user = #session.username#>

<cfquery name="getUser" datasource="myDSN">
        SELECT firstname, lastname
        FROM client
        WHERE email like '%#user#%'
</cfquery>

How may I compare the user variable to the email record in the database table?

Thank you,
Adam 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3202
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6

Reply via email to