Hi Tim, I already have a field in the form from the Classes table (The filtered select). I want to capture the ClassID from the selected class and pass it and the userID to the junction table.
Dan -----Original Message----- From: Tim Blankenship [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 10:39 AM To: [email protected] Subject: Re: [plum] Filtered Selects Yeah it came through, so you will add a field in the in the form for classID? If so couldnt you do a SQL statement to populate it? Like .. <cfquery name = "qryClasses"> SELECT ClassID FROM UserClassJunction WHERE ClassID = #Session.UserID# </cfquery> <input name="ClassID" value="<cfif isDefined('qryClasses.ClassID')>#qryClasses.ClassID#</cfif>"> Is this what you are looking for? On Tue, 1 Mar 2005 12:23:48 -0600, Nall Daniel A GS-09 336 TRSS/TSUD <[EMAIL PROTECTED]> wrote: > I have a form that populates the InformationalData table. Within that > form is a filtered select from the Classes table. I want to also > populate a many-to-many join table (UserClassJunction) with the UserID > from the logged in user (I have that as a session variable) and the > ClassID from the Classes table. Hope that makes sense. I included a > diagram of the relationship in the original e-mail. Did it get through? > > Respectfully, > Dan Nall > > -----Original Message----- > From: Tim Blankenship [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 01, 2005 10:16 AM > To: [email protected] > Subject: Re: [plum] Filtered Selects > > I am a little confused (which is normal) tell me if i am interpreting > this correctly. > You have a form that you want to populate the InformationData table? > > On Tue, 1 Mar 2005 11:56:56 -0600, Nall Daniel A GS-09 336 TRSS/TSUD > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Good Morning Everyone, > > > > I have the following relationship in my database. I have a Filtered > > Select of ClassNumber from the Classes table displayed in the > > InformationalData table form. That works well but I'm confused as to > how to > > insert UserID ( I have UserID as a session variable - thanks Jeff) and > > ClassID into the many-to-many junction table UserClassJunction when > > InformationalData form is submitted. Again, I greatly appreciate all > the > > help you have all given me. > > > > > > > > Respectfully, > > > > Dan Nall > > > > -- > 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 ********************************************************************** ********************************************************************** 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 **********************************************************************
