Ok dokey, will go for this and take on-board advice on simplification! Thanks to all.
Andy >No need for IFRAME's. Simply use javascript to trigger an onchange event in >the student drop-down. The event should locate the browser to the same >page, with a URL parameter consisting of at least the student ID that was >chosen. Query for the data for this student, then, underneath the >drop-down, simply display the data results of the selected student. > >Mike > >-----Original Message----- >From: Andy McDuff [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 18, 2006 2:27 PM >To: CF-Talk >Subject: One-to-many application on one screen > > >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:246976 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
