Tony, I'm not sure you can do this directly as PlumUser and PlumRole is a many to many relationship, with PlumUserRole there in the middle. I'm sure you could work with a custom query or a cfswitch on the list page with the right where clause extension for each role, but personally, I have a contactType field in all my apps as part of the plumUser table that more or less correlates to user role...but not always. But it does allow me to do that type of search without any pain.
David, Adam, Al, Jeff or one of the other smart guys out there might be able to give you a better answer, but I think it will take a bit of a 'hack'. Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of {tonyfelice} Sent: Tuesday, February 05, 2008 5:07 PM To: [email protected] Subject: RE: [plum] plumUserSearchForm Well, guys... With all the activity out here today, I figured I'd keep the ball rolling with a question of my own: In plumUserSearchForm.cfm (assuming that I'm in the code, and no longer in the IDE), what's the trick to include role in the search? I recall seeing this at one time, and can't recall... Thanks! Tony Felice > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:plum- > [EMAIL PROTECTED] On Behalf Of David Churvis > Sent: Tuesday, February 05, 2008 1:55 PM > To: [email protected] > Subject: RE: [plum] Plum validate input > > Oops! Al was correct. The * says "any number of occurrences of the > previous group." So all together, the expression '^[A-Za-z0-9]*$' > means: > > ^ the beginning of the string, followed by > [A-Za-z0-9] any alphanumeric character, > * repeated zero or more times (or more literally, *occurring* zero or > more > times), followed by > $ the end of the string. > > Thanks to Al - for some reason I did not get your message in my inbox, > but > you were spot on! > > Thanks, > David > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark > Fuqua > Sent: Tuesday, February 05, 2008 3:26 PM > To: [email protected] > Subject: RE: [plum] Plum validate input > > That worked. Just curious, what is the difference made by the * > symbol? > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Al > Rogers > Sent: Tuesday, February 05, 2008 2:49 PM > To: [email protected] > Subject: RE: [plum] Plum validate input > > > Thanks, Dave... I also love Plum. > > Doesn't your expression below need to include a * as in: > > '^[A-Za-z0-9]*$' > > Al > > -------------------------------- > Al Rogers [EMAIL PROTECTED] > Global SchoolNet Foundation > http://www.globalschoolnet.org > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On > > Behalf Of David Churvis > > Sent: Tuesday, February 05, 2008 9:06 AM > > To: [email protected] > > Subject: RE: [plum] Plum validate input > > > > Hi Mark, > > > > In order to validate that there is nothing but alphanumeric > > characters, use > > an expression like "^[A-Za-z0-9]$" - the ^ matches the > > beginning of the line > > and the $ matches the end. All "[a-z0-9]" would match is > > that there is an > > alphanumeric character in the string at all. The > > carat-dollar confusion is > > such a big topic in regex circles and we were originally > > considering adding > > them automatically. Let me know if it works for you :) > > > > Hope this helps, > > David Churvis > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On > > Behalf Of Mark Fuqua > > Sent: Tuesday, February 05, 2008 11:38 AM > > To: [email protected] > > Subject: [plum] Plum validate input > > > > I love plum and today I saw Adam post a reply on > > cftalk...maybe there is > > hope for the world after all. > > > > Has any one on the list (is any one still on the list?) used > > the regular > > expression attribute of the validateinput tag? > > > > I was trying to use a simple regex yesterday (disclaimer: I > > don't really > > understand regular expressions) and wasn't able to get it to > > work. I was > > trying to verify that the input had no special characters > > and no spaces. I > > tried a bunch of different combinations, but this is the one > > I most thought > > should work. [a-z0-9]. > > > > Whatever I tried, it either passed every input or failed every > input, > > irregardless of whether or not there were special characters > > or spaces. > > > > Then I had this crazy idea that I should add quotes to the > > lines in the > > validateinput tag that do the check as so... > > > > Take the existing REFind: > > > > <!--- Evaluate against a regular expression ---> > > <cfif Len(Trim(Attributes.regularExpression))> > > <cfif REFind(Attributes.regularExpression, > > Attributes.value) EQ 0> > > <cfthrow type="Validation.InvalidData" > > > > message="#Attributes.regularExpressionMessage#" > > errorCode="62200"> > > </cfif> > > </cfif> > > > > And add some quotes: > > > > <!--- Evaluate against a regular expression ---> > > <cfif Len(Trim(Attributes.regularExpression))> > > <cfif REFind("Attributes.regularExpression", > > Attributes.value) EQ 0> > > <cfthrow type="Validation.InvalidData" > > > > message="#Attributes.regularExpressionMessage#" > > errorCode="62200"> > > </cfif> > > </cfif> > > > > But that didn't work either. > > > > > > > > Any ideas? > > > > Mark Fuqua > > > > > > > > ************************************************************* > > ********* > > 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/DiscussionList > > sForm.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/DiscussionList > > sForm.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 > ********************************************************************** > > > ********************************************************************** > 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 > ********************************************************************** ********************************************************************** 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 **********************************************************************
