This displays the "Next n Headings". There can be any number of Records
under each Heading, and the number of Records can vary from one Heading to
another. It's similar to that at
http://www.northlakegroup.org/NorLakeBiz.cfm (which might be a little
broken). The following is not broken -- its website is just not yet
public. Let me know if you want to see the Queries.
best, paul
<CFOUTPUT><DIV ALIGN=center><TABLE WIDTH=600><!--- Previous Button Code
---><TR><TD ALIGN=left><CFIF Variables.PREVSTART GT
0>#VARIABLES.PREV_HREF#<B><FONT FACE=arial SIZE=2 COLOR=Maroon>Previous
#MaxClasses# Headings</A></CFIF></TD><TD ALIGN=right><!--- Next Button Code
---><CFIF Variables.NextStart LTE ListLength><CFSET Variables.Check =
ListLength - Variables.NextStart + 1><CFIF Variables.Check LT
MaxClasses><CFSET Variables.NewMaxClasses= Variables.Check><CFELSE><CFSET
Variables.NewMaxClasses = MaxClasses></CFIF>#VARIABLES.NEXT_HREF#<B><FONT
FACE=arial SIZE=2 COLOR=Maroon>Next #Variables.NewMaxClasses#
Headings</A></CFIF></TD></TR></TABLE></DIV></CFOUTPUT>
<DIV ALIGN=center><TABLE WIDTH=600 CELLPADDING=0 CELLSPACING=4
BORDER=0><TR><!---<FORM
ACTION="/ManageLS/index.cfm/CD.#URL.CFI#/CN.#URL.CFT#/ST.#VARIABLES.NEXTSTART#/HD.#VARIABLES.hdg_id#/AL.#VARIABLES.alpha#"
METHOD="POST"><TD><B><FONT FACE="arial, geneva" SIZE="2" COLOR="Maroon"><A
HREF="/AboutLS/index.cfm/IN.#VARIABLES.INIT#/CD.#URL.CFI#/CN.#URL.CFT#"
TARGET="pic"
onClick="window.open('/AboutLS/index.cfm','pic','WIDTH=600,HEIGHT=250')">list-serv</A></TD>---><TD><B><FONT
FACE=arial SIZE=2 COLOR=Maroon>organization name</TD><TD><B><FONT
FACE=arial SIZE=2 COLOR=Maroon>city</TD><TD><B><FONT FACE=arial SIZE=2
COLOR=Maroon>fait accompli</TD><TD><B><FONT FACE=arial SIZE=2
COLOR=Maroon>online?</TD></TR>
<CFOUTPUT QUERY="REQUEST.GetListings"
GROUP="Class_Name" STARTROW="#Start_Position#" MAXROWS="#MaxClasses#"><TR
BGCOLOR=6699CC><TD COLSPAN=5 ALIGN=center><FONT SIZE=-1 FACE=Arial
COLOR=FFFFFF><B>#Class_Name#</TD></TR><CFOUTPUT><TR
BGCOLOR="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffcc66'))#"><TD
HEIGHT=5><A HREF=#VARIABLES.DIR_ORG#OR.#REQUEST.GETLISTINGS.ID#.HTM><FONT
SIZE=-2 FACE=Arial><B>#REQUEST.GetListings.Org_Name#<CFIF LEN(CONTACT)GT
5>/#REQUEST.GetListings.contact#</CFIF></B></A></TD><TD> <FONT SIZE=-2
FACE=Arial>#REQUEST.GetListings.City#</TD><TD> <FONT SIZE=-2
COLOR=Blue FACE=Arial><B><CFINCLUDE
TEMPLATE="/#REQUEST.CFroot#/switch_listings.cfm"></TD><TD> <FONT
SIZE=-2 COLOR=Blue FACE=Arial><CFIF
BITAND(REQUEST.GETLISTINGS.ANDBIT,8)>Website </CFIF><CFIF
BITAND(REQUEST.GETLISTINGS.ANDBIT,2)>Email </CFIF><CFIF
BITAND(REQUEST.GETLISTINGS.ANDBIT,1)>SYP
HomePage</CFIF></TD></TR></CFOUTPUT></CFOUTPUT><CFOUTPUT><DIV
ALIGN=center><TABLE WIDTH=600><!--- Previous Button Code ---><TR><TD
ALIGN=left><CFIF Variables.PREVSTART GT 0>#VARIABLES.PREV_HREF#<B><FONT
FACE=arial SIZE=2 COLOR=Maroon>Previous #MaxClasses# Headings</A></CFIF></TD>
<TD ALIGN=right><!--- Next Button Code ---><CFIF Variables.NextStart LTE
ListLength><CFSET Variables.Check = ListLength - Variables.NextStart +
1><CFIF Variables.Check LT MaxClasses><CFSET Variables.NewMaxClasses=
Variables.Check><CFELSE><CFSET Variables.NewMaxClasses = MaxClasses></CFIF>
#VARIABLES.NEXT_HREF#<B><FONT FACE=arial SIZE=2 COLOR=Maroon>Next
#Variables.NewMaxClasses#
Headings</A></CFIF></TD></TR></TABLE></DIV></CFOUTPUT>
At 10:26 AM 3/6/01 -0500, you wrote:
>Does anyone have an example of using "Next x Records" functionality with
>nested cfoutput's (used for grouping) ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
