Yeah, and of course, post any problems here... We'll get you up and running ;)
....................... Ben Nadel www.bennadel.com -----Original Message----- From: Andrew McDuff [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 4:28 PM To: CF-Talk Subject: Re: One-to-many application on one screen 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:246980 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
