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]

 

Reply via email to