Never could get the IIF statement to work so used following code to display
across page:
<table border="0">
<CFLOOP INDEX="i" from="1" to="#badgrade.recordcount#">
<cfif #i# mod 4 is 1><TR></cfif>
<TD align="center" bgcolor="A7DAFF">
<CFOUTPUT>
#badgrade.lname[i]#, #badgrade.fname[i]#<br>
#badgrade.ssbsect_subj_code[i]#-#badgrade.ssbsect_crse_numb[i]#
(#badgrade.sfrstcr_crn[i]#)
#badgrade.grades[i]#
</cfoutput>
<TD align="center" bgcolor="A7DAFF">
<cfif #i# mod 4 is 0></tr></cfif>
</cfloop>
</table>
----- Original Message -----
From: "Jim Watkins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, July 14, 2001 3:09 AM
Subject: Re: Displaying across page
> Rob,
> Thanks for your input but I can't get your suggestion to work. Would you
> make it a little clearer?
> Thanks
>
> Jim
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, July 13, 2001 10:44 PM
> Subject: RE: Displaying iacross page
>
>
> > Use something like
> > #iif query_name.currentrow mod 3, "</td></tr><tr><td>",""#
> > in you loop or cfoutput.
> > When it reaches the 3rd record it will start a new row in your table.
> >
> > Regards,
> >
> > Rob Rusher
> >
> > Spectra Architect, Certified ColdFusion Instructor + Developer,
Certified
> > Java Programmer
> >
> > (303) 885-7044 Cell
> > (970) 472-1775 Fax
> > [EMAIL PROTECTED]
> >
> > [EMAIL PROTECTED]
> > http://www.flarenetworks.com
> >
> >
> > plan, build and integrate interactive applications and e-business
services
> > to enhance knowledge sharing, e-commerce and business communications
> > initiatives
> >
> >
> > > -----Original Message-----
> > > From: Jim Watkins [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, July 13, 2001 7:06 PM
> > > To: CF-Talk
> > > Subject: Displaying iacross page
> > >
> > >
> > > Currently the following code displays in a narrow long table on the
left
> > > side of page. as in:
> > > blah
> > > blah
> > > blah
> > >
> > > Is it possible to display this info across and down the page.as in:
> > > blah blah blah
> > > blah blah blah
> > >
> > > <CFOUTPUT Query="badgrade" group="lname">
> > > <br>
> > > <font size="3"> <b> #lname#, #fname#</font></b>
> > > <table border="0" width="auto">
> > > <TR>
> > > <TD align="center" bgcolor="A7DAFF"><b><font size="2">Course</TD>
> > > <TD align="center" bgcolor="A7DAFF"><b><font size="2">CRN</TD>
> > > <TD align="center" bgcolor="A7DAFF"><b><font size="2">Grade</TD>
> > > </B>
> > > </TR>
> > > <TR>
> > > <CFOUTPUT>
> > > <td><font size="2">#ssbsect_subj_code# #ssbsect_crse_numb#</TD>
> > > <td><font size="2">#sfrstcr_crn#</TD>
> > > <td><font size="2"><center>#grades#</center></TD>
> > > </TR>
> > > </CFOUTPUT>
> > > </TABLE>
> > > </CFOUTPUT>
> > >
> > > Jim Watkins
> > > http://www.ngtcollege.org
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
