Basic HTML version of Foils prepared May 3 1998

Foil 34 Nested CFOUTPUT and Grouping

From Java Blend and Cold Fusion High Level Database Interfaces CPS616 Web Technologies -- Spring 98. by Chao Wei Ou
1 <CFQUERY NAME="Courses" DATASOURCE="CF 3.0 Examples">
2 SELECT * FROM CourseList
3 WHERE Department_ID = '#Form.Department#'
4 ORDER BY CourseLevel
5 </CFQUERY>
6 <CFOUTPUT QUERY="Courses" GROUP="CourseLevel">
7 <H4>#CourseLevel#</H4>
8 <UL>
9 <CFOUTPUT>
10 <LI> #CourseNumber# - #CourseName#
11 </CFOUTPUT>
12 </UL>
13 </CFOUTPUT>
in Table To:

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Sat Nov 28 1998