> > In my application, there is a Role called "Church Member" that is assigned > > by the Administrator. Since the PlumUserSearchForm does not allow you to > > search by Roles, I am having a time identifying them. My first thought is > > to make a different page to do this, but there should be a way to add it to > > the Search page. Any Ideas?
> That's cool. Can you share any advice on the best way to hand code it into > the existing search page? 1) Create a DisplayExtraFormContent section on the search form. 2) Place a radio button group of three radio buttons: -- Any or no attached roles -- No attached roles -- These attached roles: 3) Directly below the third radio button, dynamically output checkboxes all named "RoleCode" that contain each defined role in your PlumRole table. 4) If the first radio button is selected, dynamically formulate a query on the search results list page that performs a simple search based on the normal PlumUser search criteria. 5) If the second radio button is selected, dynamically formulate a query on the search results list page that performs a WHERE UserID NOT IN (SELECT UserID FROM UserRole). 6) If the third radio button is selected, dynamically formulate a query on the search results list page that performs a WHERE IN on the submitted value of Form.RoleCode, which will contain a comma-delimited list of roles for which you are searching. Note: Don't forget to use ListQualify(): WHERE UserID IN (SELECT UserID FROM UserRole WHERE RoleCode IN (#ListQualify(Form.RoleCode, "'", ",", "ALL")#)) 7) Pass the resulting query object as the value of the query attribute of the DisplayList Plum custom tag on the search results list page. Important: Don't forget to alias your column names in TableName_ColumnName format. I hate this about Plum, and it's the first thing we're going to change in V1.1 (we slowly painted ourselves into a corner on this), but unfortunately you'll have to do this in V1.0. Hope this helps. :) 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 ********************************************************************** 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 **********************************************************************
