Thank you to everyone that helped!
Here's the code I ended up using:
<cfform method="POST" action=""> <select name="Client_ID" size="10">
<cfoutput query="rsClients">
<option value="#Client_ID#">#Client_LName#, #Client_FName#</option>
</cfoutput>
</select>
<input type="submit" name="Submit" value="View Client">
</cfform>
Thanks again,
Donna
On Tue, 5 Oct 2004 14:31:27 -0500, Greg Morphis <[EMAIL PROTECTED]> wrote:
> No, thats going to pass "Client_ID" as you have that as the value..
>
> form.Clients will return what you've selected in your select box
>
>
>
> On Tue, 5 Oct 2004 14:13:51 -0500, Donna French <[EMAIL PROTECTED]> wrote:
> > I thought I had this working until I tried selecting a different name
> > in the select list. I've got the page working where it displays the
> > list of clients, blah blah, but when I click the button to send them
> > to display the client details it displays the first record in the db
> > instead of the one selecting.
> >
> > Okay, here's the code from both pages:
> >
> > Page One (displays select):
> > <cfform method="post" action=""> > > <input type="hidden" name="Client_ID" value="Client_ID">
> > <select name="Clients" size="10">
> > <cfoutput query="rsClients">
> > <option value="#Client_ID#">#Client_LName#, #Client_FName#</option>
> > </cfoutput>
> > </select>
> >
> > Page Two (this is where I am getting an error):
> > WHERE Client_ID = #FORM.Client_ID#
> >
> > CFMX and Access
> >
> > Any and all help appreciated. I added the hidden field to page one
> > thinking I should be passing the Client_ID ???
> >
> > TIA,
> > Donna
> >
> > On Tue, 5 Oct 2004 09:34:30 +0100, James Smith <[EMAIL PROTECTED]> wrote:
> > > Your form tags are around the submit button but not the select boxes,
> move
> > > the <CFFORM> tag above the <TABLE> and the </CFFORM> to below the
> </TABLE>
> > > and all should be well.
> > >
> > > --
> > > Jay
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Donna French [mailto:[EMAIL PROTECTED]
> > > > Sent: 04 October 2004 22:35
> > > > To: CF-Talk
> > > > Subject: Re: Dynamic List/Menu
> > > >
> > > > yeah i think i should post the code....
> > > >
> > > > <table width="650" border="0" cellspacing="1" cellpadding="3">
> > > > <tr>
> > > > <td width="50%"> <strong>Clients:</strong><br>
> > > > <select name="Clients" size="10">
> > > > <cfoutput query="rsClients">
> > > > <option value="#Client_ID#">#Client_LName#,
> > > > #Client_FName#</option>
> > > > </cfoutput>
> > > > </select>
> > > > </td>
> > > > <td width="50%"><strong>Offenders:</strong><br>
> > > > <select name="Offenders" size="10">
> > > > <cfoutput query="rsOffenders">
> > > > <option value="#Offender_ID#">#Offender_LName#,
> > > > #Offender_FName#</option>
> > > > </cfoutput>
> > > > </select>
> > > > </td>
> > > > </tr>
> > > > <tr>
> > > >
> > > > <td width="50%">Total:
> > > > <cfoutput>#rsClients.RecordCount#</cfoutput><br>
> > > > <cfform method="post" action=""> > > > > <input type="submit" name="Submit" value="View
> > > > Selected Client">
> > > > </cfform>
> > > > </td>
> > > > <td width="50%">Total:
> > > > <cfoutput>#rsOffenders.RecordCount#</cfoutput><br>
> > > > <input type="submit" name="Submit2" value="View
> > > > Selected Offender">
> > > > </td>
> > > > </tr>
> > > > </table>
> > > >
> > > >
> > > >
> > > > Thanks,
> > > > Donna
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: Jerry Johnson <[EMAIL PROTECTED]>
> > > > Date: Mon, 04 Oct 2004 17:30:11 -0400
> > > > Subject: Re: Dynamic List/Menu
> > > > To: CF-Talk <[EMAIL PROTECTED]>
> > > >
> > > > Did you try to include a code sample, perhaps with a line of
> > > > hyphens at the top?
> > > >
> > > > If so, try sending it again without the hyphens.
> > > >
> > > > If not, here is a simple pseudo-code example
> > > >
> > > > <form action=""> > > > > <select name="ID">
> > > > <cfloop query="menuOptions">
> > > > <option value="#ID#">#label#</option>
> > > > </cfloop>
> > > > </select>
> > > > </form>
> > > >
> > > > Jerry Johnson
> > > >
> > > > >>> [EMAIL PROTECTED] 10/04/04 05:19PM >>>
> > > >
> > > >
> > > > yes
> > > >
> > > > ----- Original Message -----
> > > > From: Matthew Walker <[EMAIL PROTECTED]>
> > > > Date: Tue, 05 Oct 2004 10:14:05 +1300
> > > > Subject: RE: Dynamic List/Menu
> > > > To: CF-Talk <[EMAIL PROTECTED]>
> > > >
> > > > By list, do you mean a form select box?
> > > >
> > > > _____
> > > >
> > > > From: Donna French [mailto:[EMAIL PROTECTED]
> > > > Sent: Tuesday, 5 October 2004 10:11 a.m.
> > > > To: CF-Talk
> > > > Subject: Dynamic List/Menu
> > > >
> > > > Brain fart for the day here goes...
> > > >
> > > > I have a dynamic list/menu & a submit button below, and I
> > > > want to let the user select from the list, click the button,
> > > > go to a page to display record details.
> > > >
> > > > Is it Monday or did I lose brain cells over the weekend?
> > > >
> > > > --
> > > >
> > > > Donna French
> > > > [EMAIL PROTECTED]
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
