can you send me in the right direction in regards to implementing this using a VBDLL.<BR><BR>User Interface for Add New User (HTML/ASP)<BR>---------------------------------<BR>1. UserName<BR>2. Password<BR>3. Confirm Password<BR>4. List of Checkboxes for Groups<BR><BR>I need to add the User to the tblUsers in addition<BR>to adding the username and group ID's to the tblUsersGroups<BR>table. Here is the table Schema for the second table:<BR><BR>username | group_id<BR>-------- --------<BR>mrsonso 5<BR>mrsonso 3<BR><BR>etc, etc.<BR><BR>How should I plan to handle this? Can you send me in the right direction? How would you approach this? Thanks.
Check this link<BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=153<BR><BR>it tells you how to LOOK for 3 records but you can change that to do an insert into the db.<BR><BR>follow it to the part where they do an in...but instead you will do a split and get an array of all the IDs the user "checked" then you will loop through the resulting array<BR><BR>dim sSQL<BR>for i = 0 to ubound(arrayName, 2)<BR>sSQl = sSQL & "insert into TableName (UserName, group_id<BR>)values ('" & UserNameVariable & "', " & arrayName(i) & ") "<BR>next<BR>ConnectionObject.Execute(sSQL)<BR><BR ><BR>that way you will do an insert...you MAY want put it in a transaction and check the number of records effected and compare that with the Ubound of the array to see if they are the same...if they are only then commit.<BR><BR>