On the action page of your registration I would do the following.
1. Select qry - Select userid from Plumuser where form.email = email
2. Update qry - Insert into PlumUserRole (UserID, RoleCode) Values
('Qry1.userid', 'STUDENT')PS Make sure you have STUDENT defined in the PLUMROLE table as a ROLECODE. Hope this helps. On Tue, 8 Feb 2005 11:04:53 -0600, Nall Daniel A GS-09 336 TRSS/TSUD <[EMAIL PROTECTED]> wrote: > The users are students and have to fill out a lengthy (several pages) > registration form. I'll have them goto the login page, login and if > they are not in the database redirect to a registration form. All users > logging in this way will be students. All other users, Admin, faculty, > etc will be added manually. > > Respectfully, > Dan Nall > > -----Original Message----- > From: Tim Blankenship [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 08, 2005 8:59 AM > To: [email protected] > Subject: Re: [plum] > > Can you give a little more info. Will your users fill out a > reqistration form for the site? or are you going to have them goto the > login page login and if they are not in the database redirect to a > registration form or are you wanting to have them login in and if they > are not found automatically add them with some default security? > > On Tue, 8 Feb 2005 10:36:02 -0600, Nall Daniel A GS-09 336 TRSS/TSUD > <[EMAIL PROTECTED]> wrote: > > Is it possible to automatically assign a role to a user when they > first > > login? > > > > Respectfully, > > Dan Nall > > > > ********************************************************************** > > 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 > > ********************************************************************** > > > > -- > Tim Blankenship > [EMAIL PROTECTED] > > ********************************************************************** > 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 > ********************************************************************** > -- Tim Blankenship [EMAIL PROTECTED] ********************************************************************** 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 **********************************************************************
