I think you want the tag cf_twoselectsrelated Russ Michaels Macromedia/Allaire Certified ColdFusion Developer CFDeveloper The free resource and community for ColdFusion developer. http://www.cfdeveloper.co.uk
Join the CFDeveloper discussion lists. To subscribe send an e-mail to [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 25 May 2004 16:24 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Update > > > > Hello again, > > I want to have a select llist contain details relevant to a > previous select list > > Show the first select list .... > > <cfform action="modrep_results.cfm" enctype="multipart/form-data"> > <!--- Select Menu Type---> > <tr> > <td colspan="3" valign="top" align="left"> > <font face="arial, Arial, Helvetica"> > <font size="2"> > <font color="#000080"><b>Please > select which menu the report to modify is under.</b><br> > </font> > <font face="arial, Arial, Helvetica"> > <font size="2"> > This is the menu from the default > screen on the performance website. > <p> > <cfselect name="selected_menu" > size="1" > message="Oops you have not selected a > Menu area" > query="get_menu" > value="menu_id" > display="menu_name" > required="Yes"> > </cfselect> > </font> > </td> > </tr> > > Set a query with the where = to the selected item .... (Hmm I > think I need a bit of javascript here ....) > > <CFQUERY NAME= "get_phase_types" DATASOURCE= "WebUserDSN"> > SELECT Phase_ID, Menu_Group > FROM Details > WHERE (Menu_Group = #form.selected_menu# > <!--- cant do this so how???? --->) > GROUP BY Phase_ID > </CFQUERY> > > I think this shows the idea but how do I do it? > > Regards - Paul > > > > > ************************************************************** > *********************************** > The information contained within this e-mail (and any > attachment) sent by Birmingham City Council is confidential > and may be legally privileged. It is intended only for the > named recipient or entity to whom it is addressed. If you are > not the intended recipient please accept our apologies and > notify the sender immediately, or telephone +(44) 121 303 > 6666. Unauthorised access, use, disclosure, storage or > copying is not permitted and may be unlawful. Any e-mail > including its content may be monitored and used by Birmingham > City Council for reasons of security and for monitoring > internal compliance with the office policy on staff use. > E-mail blocking software may also be used. Any views or > opinions presented are solely those of the originator and do > not necessarily represent those of Birmingham City Council. > We cannot guarantee that this message or any attachment is > virus free or has not been intercepted and amended. > > ************************************************************** > *********************************** > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
