George L.
|
| Posted: 05/30/2002, 8:25 AM |
|
Can someone please let me know if they have an example of using a multiple select and inserting the multiple selections into a database?
I am in dire need to get something similar to this done.
Here is my intent/background:
I am trying to create users that belong to a particular group. This is for security purposes so that I can add group privileges to my C.C pages. The problem is that I need to have users that can be assigned multiple groups. Not just one group.
I need to store the groups assigned to a particular user in an array such as (99,101,201,305),etc. This group id array could be set as a session parameter upon login. I then use a custom check_group function that I built to check on each page load to see if the user's group array has the group id assinged to each page. This will allow more complex security arrangements. (Even though C.C's simple but effective security function works well as is.)
What im looking for help in is this:
ON MY "CREATE NEW USER" FORM, I HAVE A DROP-DOWN LISTBOX THAT ALLOWS THE ADMIN TO CHOOSE THE GROUP TO BE ASSINGED FROM A GROUPS TABLE. THE PROBLEM IS THAT I CAN ONLY CHOOSE ONE GROUP AT A TIME.
i KNOW HOW TO CREATE A "MULTIPLE" LISTBOX BY ADDING MULTIPLE IN CUSTOM SHOW EVENT. BUT I CANNOT FIGURE OUT HOW TO TAKE THE MULTIPLE SELECTIONS AND SUBMIT THEM AS ONE ARRAY. IF I CAN GET THEM INTO AN ARRAY, THEN I CAN FIGURE OUT HOW TO ADD CUSTOM CODE TO INSERT INTO MY DATABASE TABLE.
I would gladly post this to Tips and Articles to share this if i can get it to work well. Something along the lines of "Advanced page security".
Anyhow,here is my email if someone can help me offline--> mailto:res051us@verizon.net
Thanks in advance.
g.
|
|
|
 |
George L.
|
| Posted: 05/30/2002, 2:24 PM |
|
|
|
|
|
Nicole
|
| Posted: 05/31/2002, 4:35 AM |
|
George,
please refer to the thread:
http://www.gotocode.com/disc_viewt.asp?mid=11087&
I hope it would be helpful
|
|
|
|
|
