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
**********************************************************************
