I'm trying to set session variables for login with the code below.
It works fine on my local dev pc, but on the production server,
no session variables are being set. Is the code below not appropriate?
Thanks,
Rick
<cfcomponent displayname="manager_data" hint="Contains manager database query"
output="false">
<cffunction name = "getmanagerData">
<cfargument name = "email_address" type="string"
required="yes">
<cfargument name = "password" type="string"
required="yes">
<cfquery name="get_manager" datasource="#application.dsn#">
select manager_id, email_address, password,
announcements,
res_announcements, rental_properties,
new_communities, agents,
featured_properties, open_houses,
local_websites, fort_stewart,
our_community, approved_cities,
site_managers
from site_managers
where email_address =
'#arguments.email_address#'
and password = '#arguments.password#'
</cfquery>
<cfset managerStruct = structNew()>
<cfif get_manager.recordcount gt 0>
<cfset session.manager_id = get_manager.manager_id>
<cfset session.announcements =
get_manager.announcements>
<cfset session.res_announcements =
get_manager.res_announcements>
<cfset session.rental_properties =
get_manager.rental_properties>
<cfset session.new_communities =
get_manager.new_communities>
<cfset session.agents = get_manager.agents>
<cfset session.featured_properties =
get_manager.featured_properties>
<cfset session.open_houses = get_manager.open_houses>
<cfset session.local_websites =
get_manager.local_websites>
<cfset session.fort_stewart = get_manager.fort_stewart>
<cfset session.our_community =
get_manager.our_community>
<cfset session.approved_cities =
get_manager.approved_cities>
<cfset session.site_managers =
get_manager.site_managers>
<cfset managerStruct.login = "Login Successful">
<cfelse>
<cfif not len(trim(arguments.email_address))>
<cfset managerStruct.emailerror = "Please enter
your email address">
</cfif>
<cfif not len(trim(arguments.password))>
<cfset managerStruct.passworderror = "Please
enter your password">
</cfif>
<cfset managerStruct.login = "Login Unsuccessful">
</cfif>
<cfreturn managerStruct />
</cffunction>
</cfcomponent>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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/cf-talk/message.cfm/messageid:317510
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
