now the only piece I lack is to be able to pass in a list of values to a
function or something and get returned all the unique combinations. Then I
can compare the unique combinations to the union query results and find my
violations. Anyone know where I can find a function to pass in a comma
delimited string of values and get all the unique combinations returned?
Thanks for listening.
Casey Cook
---------------
This request has blown me away, I cant get my hands around it. The current
user roles lists all the roles the user is in. The 2 element array is
combinations of roles which are not allowed. The end result is the user
will be removed from the roles which conflict. I dont really know where to
start on this one. Has anyone done anything like this or know where to
look? please see below.
Current User roles
1
2
4
6
7
Invalid Combinations
Element1 Element2
1 2
2 1
3 3
7 5
9 6
4 6
So, if I look at the data the user is currently in 3 invalid combinations
of roles. (1 and 2) (2 and 1) and (4 and 6)
Thanks,
Casey Cook
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
