just to throw another option out there... it could potentially all be done client side via javascript. create a 2d javascript array based on your query data. the onchange event from dropdown 1 would update the options in dropdown 2 based on that array.
On Nov 27, 2007 11:35 AM, Steve Sequenzia <[EMAIL PROTECTED]> wrote: > Hi All, > > Can I get some help figuring out how to connect two dropdowns dynamically? > > I am working a shoe database and I need to allow the user to select a size > from a dropdown and then from there I need to have another dropdown called > quantity updated with the amount of quantity based on the size that is > selected. All the data is coming from a MSSQL Database and I am using > ColdFusion 8. > > I would like to do this via Ajax and not refresh the entire page. I know how > to do it by refreshing the entire page but not the Ajax way. > > Any help on this would be great. > > Thanks in advance. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
