RE: dynamically create drop downs. based on number needed?

[Yager, Brian T Contractor/NCCIM]

I just did this in ASP (but the CF equivilent is just as easy, if you want a
copy of my code, drop me a line.  


Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342


-----Original Message-----
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 9:04 AM
To: CF-Talk
Subject: dynamically create drop downs. based on number needed?


hello all.
i have a form i need to re-create
in the paste there is a section for 

"Team Member Info", here i just had 10 text fields where the project manager
would enter in his team members.

but now i want to pull the "Member_Names" from an existing db in a drop down
list, i know how to do this.

but at the start of this section, i want the user to be asked 
"How Many Team Members?" then depending on the number selection
i would want that many "Member_Names" Drop Downs Created.

so if there were where only 3 team members, 3 drop downs would appear.


So how would i go about doing this.
would this be a JavaScript thing?

would i first need to select 3 then hit submit, or could i do it on an on
change event & how?

also how would the select boxes then be named?

If there is an example i have over looked in the WACK book, just give me a
page number


right now the way i am doing 1 drop down is

<cfquery name="rs_Team_Members" datasource="Project_Setup">
SELECT EmployeeID, FirstName, LastName, Email 
FROM tbl_Employee 
ORDER BY LastName 
DESC; 
</cfquery>

<select name="EmployeeID">
 <cfloop query="rs_Team_Members">
  <option value="<cfoutput>#rs_Team_Members.EmployeeID#</cfoutput>" <cfif
(#rs_Team_Members.EmployeeID# EQ
#rs_Team_Members.EmployeeID#)>SELECTED</cfif>><cfoutput>#rs_Team_Members.Las
tName# #rs_Team_Members.FirstName#</cfoutput></option>
 </cfloop>
</select>

thanks
-paul



-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 5:44 PM
To: CF-Talk
Subject: Re: Remove spaces


rereplace()
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists