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