>What makes you say that it is timming out?
I think because in the application.log there is a message that one of the
session variables "Element userid is undefined in session". This variable is
set in the page after the user's login/password is accepted.
This is the code which processes the user login/password and sets all the
SESSION variables.
<CFQUERY NAME="CheckUser" DATASOURCE="#pdmin_dsn#">
SELECT user_name as UserID, Password, user_type
FROM user_dat
WHERE user_name = '#Form.User_name#'
</CFQUERY>
<CFQUERY NAME="getnewstype" DATASOURCE="#name_dsn#">
SELECT newsName
FROM newsType
WHERE newsTypeID = #Form.newstype#
</CFQUERY>
<CFLOCK scope="SESSION" type="EXCLUSIVE" timeout="60" throwOnTimeout="No">
<CFIF (#SESSION.LOGGEDIN# EQ "FALSE")>
<CFIF CHECKUSER.RECORDCOUNT GREATER THAN 0>
<CFIF CHECKUSER.PASSWORD IS FORM.PASSWORD>
<CFSET SESSION.LOGGEDIN = TRUE>
<CFSET SESSION.USERID = CHECKUSER.USERID>
<CFSET SESSION.USERTYPE = CHECKUSER.USER_TYPE>
<CFSET SESSION.NEWSTYPEID = Form.newstype>
<CFSET SESSION.NEWSNAME = getnewstype.newsName>
<CFCOOKIE NAME="LoggedIn" VALUE = "#CHECKUSER.UserID#">
<CFCOOKIE NAME="CFID" VALUE="#SESSION.CFID#">
<CFCOOKIE NAME="CFTOKEN" VALUE="#SESSION.CFTOKEN#">
<cfoutput><cflocation
url="news.cfm?current_newsTypeID=#form.newsType#"></cfoutput>
<CFELSE>
<CFOUTPUT>
<SCRIPT>
alert("Sorry, Invalid password. Try again.");
self.location="#base_path#/admin/main/index.cfm";
</SCRIPT>
</CFOUTPUT>
</CFIF>
<CFELSE>
<CFOUTPUT>
<SCRIPT>
alert("User #FORM.USER_name# was not found in
our database.");
self.location="#base_path#/admin/main/index.cfm";
</SCRIPT>
</CFOUTPUT>
</CFIF>
<CFELSE>
<cfoutput>
<SCRIPT LANGUAGE="JavaScript">
location.href('news.cfm?current_newsTypeID=#form.newsType#');
</SCRIPT>
</cfoutput>
</CFIF>
</CFLOCK>
Thanks.
Mullai
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260982
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
