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 **********************************************************************
