Sorry for the large block of code but here is what I use. It automatically
makes a << < 1 2 3 4 5 6 7 8 9 10 > >> and form to select number of records
returned.
It uses the <CF_ROWS> and <CF_ResultPages> tags from the gallery. I had to
add a little code to get it to work for grouped queries. Look between the
tags and the innermost grouping. I could not do it for the grouped records
as a whole.
<TABLE cellpadding="1" cellspacing="1" border="0"><!---code allowing an
administrator to add a new user--->
<!---Labels for the query results--->
<TR>
<CFOUTPUT>
<TD class="blacktext" bgcolor="#local.displaycolor#">Institution
</TD>
<TD class="blacktext" bgcolor="#local.displaycolor#">College
</TD>
<TD class="blacktext" bgcolor="#local.displaycolor#">School
</TD>
<TD class="blacktext" bgcolor="#local.displaycolor#">Department
</TD>
<TD class="blacktext" bgcolor="#local.displaycolor#">Degree or Program
</TD>
<TD class="blacktext" bgcolor="#local.displaycolor#">Last Name
</TD>
<TD class="blacktext" bgcolor="#local.displaycolor#">First Name
</TD>
<TD class="blacktext" bgcolor="#local.displaycolor#">Email
</TD>
<TD bgcolor="#local.displaycolor#">
</TD>
</CFOUTPUT>
</TR><!---loops through the results and displays all users--->
<CFOUTPUT query="QueryStudentAll" group="institution">
<TR>
<TD colspan="9" class="formlabelleft">#QueryStudentAll.institution#
</TD>
</TR>
<CFOUTPUT group="college">
<TR>
<TD colspan="1">
</TD>
<TD colspan="8" class="formlabelleft">#QueryStudentAll.college#
</TD>
</TR>
<CFOUTPUT group="school">
<TR>
<TD colspan="2">
</TD>
<TD colspan="7" class="formlabelleft">#QueryStudentAll.school#
</TD>
</TR>
<CFOUTPUT group="department">
<TR>
<TD colspan="3">
</TD>
<TD colspan="6" class="formlabelleft">#QueryStudentAll.department#
</TD>
</TR>
<CFOUTPUT group="degree_or_program">
<TR>
<TD colspan="4">
</TD>
<TD colspan="5" class="formlabelleft"><br>
#QueryStudentAll.degree_or_program#<br>
<CFSETTING ENABLECFOUTPUTONLY="YES">
<CFSET theSchool = QueryStudentAll.sch_id><!--- Query returning search
results --->
<CFQUERY datasource="#request.DSN#" name="QueryStudentBySchool">
SELECT DISTINCT stu.stu_id, stu.sch_id, stu.stu_fname, stu.stu_active,
stu.stu_lname, stu.stu_email, schools.institution, schools.college,
schools.school, schools.department, schools.degree_or_program
FROM
stu, schools
WHERE
schools.ID = stu.sch_id
AND schools.ID = #theSchool#
AND stu.stu_active = 1
<CFIF Client.UserType NEQ "Administrator">AND stu.sch_id IN
(#client.schoolsaffiliatedwith#)
</CFIF>
<CFIF Client.UserType EQ "Student">AND stu.stu_id IN
(#client.UserID#)
</CFIF>
<CFIF Criteria NEQ ''>AND #PreserveSingleQuotes(Criteria)#
</CFIF>
ORDER BY
schools.institution ASC,
schools.college ASC,
schools.school ASC,
schools.department ASC,
schools.degree_or_program ASC,
stu.stu_lname ASC,
stu.stu_fname ASC
</CFQUERY>
<CF_ROWS maxrows="10">
<cfif attributes.fuseaction IS "pick_from_list">
<cfset Local.Fuseaction=attributes.XFA.onPickADifferentStudent>
<cfelse> <cfset Local.Fuseaction=attributes.XFA.onList>
</cfif>
<CF_ResultPages
query="QueryStudentBySchool"
maxpages="10"
droprows
all ReturnTo="#attributes.self#?fuseaction=#Local.Fuseaction#">
<cfif (StartRow + MaxRows) GTE QueryStudentBySchool.RecordCount>
<cfset EndRow = QueryStudentBySchool.RecordCount>
</cfif>
<CFSETTING ENABLECFOUTPUTONLY="NO"></TD>
</TR>
<!--- List all students associated with any schools that the current user is
associated with. ---> <cfif StartRow LTE
QueryStudentBySchool.RecordCount>
<!--- <cfif Not NoMoreRecords IS "1"> --->
<CFLOOP query="QueryStudentBySchool" startrow="#StartRow#"
endrow="#EndRow#">
<TR>
<TD colspan="5">
</TD>
<TD align="left" bgcolor="#IIf(CurrentRow Mod 2,
DE('#request.listoddcolor#'), DE('#request.listevencolor#'))#"
class="smallertext">
<CFIF client.UserType IS
"Administrator">#QueryStudentBySchool.stu_id# -
</CFIF>
#QueryStudentBySchool.stu_lname#
</TD>
<TD align="left" bgcolor="#IIf(CurrentRow Mod 2,
DE('#request.listoddcolor#'), DE('#request.listevencolor#'))#"
class="smallertext">#QueryStudentBySchool.stu_fname#
</TD>
<TD align="left" bgcolor="#IIf(CurrentRow Mod 2,
DE('#request.listoddcolor#'), DE('#request.listevencolor#'))#"
class="smallertext"><A href="mailto:#QueryStudentBySchool.stu_email#">
#QueryStudentBySchool.stu_email#
</A>
</TD>
<TD bgcolor="#IIf(CurrentRow Mod 2, DE('#request.listoddcolor#'),
DE('#request.listevencolor#'))#" class="smallertext">
<CFIF attributes.Fuseaction EQ "pick_from_list"><A
href="#attributes.self#?fuseaction=#attributes.XFA.onPickFromList#&student_i
d=#QueryStudentBySchool.stu_id#&school_id=#QueryStudentBySchool.sch_id#">Pic
k</A><CFELSE>
<CFIF ListFindNoCase(#Client.Permissions#,"estu") OR
Client.UserType EQ "Student"><A
href="#attributes.self#?fuseaction=#attributes.XFA.onEdit#&StudentID=#QueryS
tudentBySchool.stu_id#&menu=address"> Edit</A></CFIF>
<CFIF ListFindNoCase(#Client.Permissions#,"dstu")><A
onClick="return
confirmSubmit('#JSStringFormat(QueryStudentBySchool.stu_fname)#
#JSStringFormat(QueryStudentBySchool.stu_lname)#')"
href="#attributes.self#?fuseaction=#attributes.XFA.onDelete#&StudentID=#Quer
yStudentBySchool.stu_id#"> Delete
</A>
</CFIF>
</CFIF>
</TD>
</TR>
</CFLOOP> </cfif>
</CFOUTPUT>
</CFOUTPUT>
</CFOUTPUT>
</CFOUTPUT>
</CFOUTPUT>
</TABLE>
----- Original Message -----
From: "S. R." <[EMAIL PROTECTED]>
To: "Fusebox" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 8:26 AM
Subject: Nested Cfouput w/ Next N Functionality
> Does anyone have an example of using "Next x Records" functionality with
nested cfoutput's (used for grouping) ?
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.231 / Virus Database: 112 - Release Date: 2/12/2001
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
