Hi there, I'm relatively new to CF (although Ben's WACK book is being throughly digested) but fine with SQL, DB design and no problems on general coding. I'm working on a small test app to display courses being attended by students. The idea is to put everything on one single HTML page. At the top of the page would appear a drop-down list of students (retrieved via cfselect tag & SQL from a CFC), and on the bottom-half of the screen would appear the courses being or have been attended. There are 3 tables: student, course and student-course (many-to-many relationship broken out to two sets of 1-to-many), student-course being the link table. Nothing fancy for the moment...
What's the best way to do this? Use IFRAME's? If so, what's the general approach? How do I pass the selected student (from the top frame) in order to query the courses and display them in the bottom-half of the screen (without having to use a button)? Is this done via Javascript or can this be done via CF? Any help / guidance / pseudo-code would be gratefully appreciated. Andy McDuff Madrid, Spain ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246957 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
