Yes, I see how that can work. Only problem is that if Item 1 exits "n" times in Column A in database it is listed "n" times in the list. Using "GROUP BY" on the query does not work, any way around that?
-----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 2:03 PM To: CF-Talk Subject: RE: How Do I Create Dynamic Arrays to Populate Select Boxes? not technically correct. it will do something like this Column A Column B -------- -------- Item 1 Item 1 - Sub 1 Item 1 Item 1 - Sub 2 Item 1 Item 1 - Sub 3 Item 2 Item 2 - Sub 1 Item 2 Item 2 - Sub 2 Item 2 Item 2 - Sub 3 when selecting item 1 from the first box, it will show the subs for item 1 in the second. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 1:52 PM To: CF-Talk Subject: RE: How Do I Create Dynamic Arrays to Populate Select Boxes? First thing I looked at, actually have used it for another app. The difference here is that, the way the TwoSelectsRelated Tag works (my interpretation) is that it takes your choice from Select Box 1 and gives you the corresponding value in Select Box 2. Example, Column A is database populates Select Box 1. When choice is made, Select Box 2 is populated with the corresponding value. Column A Column B -------- -------- John Doe [EMAIL PROTECTED] Jane Doe [EMAIL PROTECTED] If I choose John Doe from Select Box 1, his email [EMAIL PROTECTED] will poplulate Select Box 2. What I want though is to populate Select Box 2 with choices from not only Column B, but also if I have a Column C,D,E and F. Does that make sense? -----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 1:32 PM To: CF-Talk Subject: RE: How Do I Create Dynamic Arrays to Populate Select Boxes? look into Nate Weiss' TwoSelectedRelated tag on the allaire development gallery. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 1:29 PM To: CF-Talk Subject: How Do I Create Dynamic Arrays to Populate Select Boxes? I want to create an application that allows the end-user to first select a category from select box A, which entails populates select box B with that category's data drawn from the database. In other words, when John Doe selects "Employment" from select box A, select box B populates with data taken from several fields through an OnSelect function within select box A. I would like this application to occur on the same page. I figure I'll have to create an array which collects data corresponding to what is selected in select box A, and this is where I'm lost. Any help would be appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
