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
