Thanks Adam,
"Couple of minutes and bug free" is my kind of modification.
However, since you know my some by now, you know I'm sometimes
stubborn--but
willing to explore and implement.
I did add a new table for UserTitles because I want to set these values
separately of user input to assure consistency. I need the users in this
app to have to pick the UserTitle from a ListBox instead of type it in.
I made the table AND then modified the UserQuery that I found in
security.cfc to include the UserTitle in its list of SELECT columns. I
tested a copy of this query outside of the cfc and it works fine,
giving me
just what I wanted.
Here's my modified query (lines 150 thru 171 in security.cfc
<cfquery name="userQuery"
datasource="#Application.dbDSN#"
username="#Application.dbUsername#"
password="#Application.dbPassword#">
SELECT
UserID,
FirstName,
LastName,
Email,
Password,
LoginID,
UserTitle,
Status
FROM
PlumUser p
JOIN
BCC_tbl_UserTitles u
ON
p.UserTitleID = u.UserTitleID
WHERE
Email = <cfqueryparam
value="#Trim(Arguments.email)#"
cfsqltype="CF_SQL_VARCHAR">
</cfquery>
BUT now I don't know how to get the UserTitle OUT and use it. I am
already
using #session.NameOfLoggedInUser# successfully in the site. My thinking
was simply to create # session.TitleOfLoggedInUser# to use along with it.
The code at line 102 <!--- Set cookies for auto-login and persist the
user's full name --->
Looked like a logical place to add this line:
Session["TitleOfLoggedInUser"] = "#userQuery.userTitle#";
But it is not working. (Mainly I'm sure because I don't really know
what I'm
doing, just trying to follow your lead and learn from you.
I am out of my league in further modifying security.cfc (if indeed that's
where I should make the mod's) to get this new query value out where I
can
use it.
Can you help?
Thanks,
Dan Kaufman
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adam
Churvis
Sent: Wednesday, May 11, 2005 1:33 PM
To: [email protected]
Subject: Re: [plum] Need to add a user title
I would add a NULLable column named Title to the PlumUser table and then
just add a field for it on the user management forms on the admin side of
the site. Takes all of a couple of minutes total to modify, bug free.
What you suggest for modifying Security.cfc is exactly the kind of
modifications to Plum that we encourage developers to explore and
implement.
Respectfully,
Adam Phillip Churvis
Member of Team Macromedia
http://www.ProductivityEnhancement.com
Download Plum and other cool development tools,
and get advanced intensive Master-level training:
* C# & ASP.NET for ColdFusion Developers
* ColdFusion MX Master Class
* Advanced Development with CFMX and SQL Server 2000
----- Original Message ----- From: "Dan" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, May 11, 2005 11:17 AM
Subject: [plum] Need to add a user title
In my Plum app I have a need for some users, not all, to have a Title
(like
General Manager, Vice-President, etc.)
My fist thought is to create a new _db tbl "UserTitles"
UserTitleID PK, int, identity
UserTitle char
And then add UserTitleID to the PlumUser tbl
From an Admin side, a User will NOT be able to add/edit his/her Title.
This
can only done by a "senior" ROLE person.
How would I go about doing this within Plum's methodology?
2nd question: I will need with in the site pages to display the User's
Title with their name ( NameOfLoggedInUser )
I see where NameOfLoggedInUser is created in Security.cfc. Would it be
correct to modify/add this procedure to this CFC
}
f(Application.persistentScope EQ "Session") {
Session["NameOfLoggedInUser"] = "#userQuery.FirstName#
#userQuery.LastName#";
Session["TitleOfLoggedInUser"] = "#userQuery.userTitle #";
} else {
Client["NameOfLoggedInUser"] = "#userQuery.FirstName#
#userQuery.LastName#";
Client["TitleOfLoggedInUser"] = "#userQuery.userTitle #";
}
I would, of course, have to modify the userQuery to pull the userTitle
from
a JOIN on the PlumUser and UserTitles table.
Thanks,
Dan Kaufman
An Elephant Never Forgets
[EMAIL PROTECTED]
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
